Get a field from three fields

[#1]

Hi

can any one help me on the below scenario, I have

ID, Source, global value, face value, total value  from these fields I would like to calculate one more field expected output.

I tried it but I am not getting desired results

need a column from the fields( (Facevalue+totalvalue)*global value) group by Source, ID. How to get it?

PFA for sample data.

Expected result for ID1, source Logistic output: ((1.084859+1.0943367)*0.921033) =2.007113

Regards

john

[Gysbert_Wassenaar · Accepted solution]

Like this I reckon:

LOAD

     ID,

     Source,

     Facevalue,

     [Global value],

     [total value],

     rangesum(Facevalue,[Global value]) * [total value] AS [Expected Out Put]

FROM ...