HOW TO SUM A EXPRESSION

Question

Hi I have to expression salesT = sum(sales) and CostT ) = sum(cost), with this two expression, i calculated ratio = CostT/salesT.&nbsp;&nbsp;I need to know how to sum(ratio)&nbsp; as a individual value, i need to have Ratio as a independent columno in order to sum data.&nbsp;&nbsp;Bellow my data example.&nbsp;&nbsp;fechasalescostRatio&nbsp;01/01/20191023541200&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,011702/01/201915353101250&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,000803/01/2019230296501280&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,000104/01/20193454447501310&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,000005/01/201951816712501340&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0,0000&nbsp;Thanks!&nbsp;

amitchandak · Answer

I am not sure I got it completely.&nbsp;I think Ratio should be calculated like&nbsp;Ratio = calculate(divide(sum(sales),sum(cost))It will calculate is at all level.&nbsp;Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @ Thanks.

Forum Discussion

HOW TO SUM A EXPRESSION

1 Reply

Related content

Help!!! Expression Error

Regular expression

Running sum

Filtering a Sum

Improper Sum with slicer

fecha	sales	cost	Ratio
01/01/2019	102354	1200	0,0117
02/01/2019	1535310	1250	0,0008
03/01/2019	23029650	1280	0,0001
04/01/2019	345444750	1310	0,0000
05/01/2019	5181671250	1340	0,0000