Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
Have you any iedeas sum per line
EU-COMPINED * LITRES = Sum per line ^ 100
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?
Can you give example skript?
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.