Find And Aggregation

[Kuldeepmathur]

Hi,

I have 2 tables the first table have Model Number, Option Code, Extra Dollar, Base Dollar

Another one has  Model Number, Set Code 

E.g : index data file will have

if Model Number 3504 and  Base dollar Value is 6780

And Option Code : 

AE=220(Extra Dollar)

FC=118

TR=74

and if our original configuration may have model number 3504 and Set Code "FC, TR"

So total should be (6780+118+74) 6972

Attaching Files(F1, F2 as Input) for your reference the result should be identical to the F3 file .

Thanks,

Kuldeep

[benakesh · Accepted solution]

Hi @Kuldeepmathur ,

Can you check the output file : F3   ?   I think all amounts should be >  base amount . 

[Kuldeepmathur]

Thank you for the quick solution.