sum per line

[kkarlste]

Hi

Have you any iedeas sum per line

EU-COMPINED * LITRES = Sum per line ^ 100

[Digvijay_Singh]

Didn't understand, what do you get if you simply take EU-Combined and Litres as dimensions and there multiplication (or sum() of them multiplied) as expression? Another expression with last expression * 100?

[kkarlste]

Can you give example skript?

[Digvijay_Singh]

Data:

Load * inline [

"EU-COMBINED",LITRES

8.9,6077

8.9,61.3

8.9,52.88

8.9,59.47

8.4,47.18 ];

Final:

Load

  "EU-COMBINED",LITRES,

  Sum("EU-COMBINED")*Sum(LITRES) as SumPerLine,

  Sum("EU-COMBINED")*Sum(LITRES)*100 as "SumPerLine*100"

Resident Data

Group By "EU-COMBINED",LITRES

;

Drop table Data;

But you can calculate the expression in the straight table in UI directly.