Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
When I am calculating the percentage of red marked column by expression total, it is giving me the wrong data. Can anybody help me ?
Also i don't think you can use Aggregation functions with column references!!
as you said A and B are expressions which means they have aggregations functions like sum,min or max
so Sum(A) or Sum(B) will never work!
To have Expression totals you need an aggregation function so i suggest you rewrite the expression for A and B
C = Full expression for B / Full expression for A * 100
Yes...It is working for me..Thanks for your help.