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

F3.xlsx

F2.xlsx

F1.xlsx

benakesh

Hi @Kuldeepmathur ,

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

find_and_agr.yxmd