Expression Total

[#1]

Hi,

I need help with the Expression total, how do I get it to be 21,25% instead of 63,90%?

S	sum(P)*sum(T)	SUM(P)	Column(1) / Column(2)
	424,90	2 000,00	63,90%		21,25%
a	275,60	1 300,00	21,20%
b	106,50	500,00	21,30%
c	42,80	200,00	21,40%

/J

[alexandros17]

Here it is

[rubenmarin · Accepted solution]

You can change the last expression to:

If(Dimensionality()=0, sum(aggr(sum(P)*sum(T), S))/Sum(P),

Column(1) / Column(2))

[#4]

Sorry, I need to be more precise. I would like it to show 424,9 / 2000 = 0,21245 or 21,245%

[#5]

Fantastic - Thank you!