Get a field from three fields

Thu, 30 Jul 2015 07:27:19 GMT

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

Re: Get a field from three fields

Gysbert_Wassenaar — Thu, 30 Jul 2015 07:39:18 GMT

Like this I reckon:

LOAD

ID,

Source,

Facevalue,

[Global value],

[total value],

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

FROM ...