Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You can change the last expression to:
If(Dimensionality()=0, sum(aggr(sum(P)*sum(T), S))/Sum(P),
Column(1) / Column(2))
Here it is
You can change the last expression to:
If(Dimensionality()=0, sum(aggr(sum(P)*sum(T), S))/Sum(P),
Column(1) / Column(2))
Sorry, I need to be more precise. I would like it to show 424,9 / 2000 = 0,21245 or 21,245%
Fantastic - Thank you!