Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community
I have 2 Expressions & 1 Dimension in my Straight Table:
Dimension:
Month
Expressions:
1) Sum(Left)
2) Sum(Closed)/12
I am Creating New Expression:
3) Sum(Left)/Column(2) - It is Working & Giving Me the Result.
4) Sum(Left)/Sum(Closed)/12 - It is Not Working & Not Giving Me the Result.
Am I doing something wrong in the Expression???
How to Resolve No.4) Issue??
Hi try below
4) Sum(Left)/(Sum(Closed)/12) - It is Not Working & Not Giving Me the Result.
Hope it help.
Regards
ASHFAQ
Hi try below
4) Sum(Left)/(Sum(Closed)/12) - It is Not Working & Not Giving Me the Result.
Hope it help.
Regards
ASHFAQ
I should have to know the data but try this:
1) Sum(Left/Closed)/12
Verify that sum(Closed) is not 0 otherwise you will have a null value
Try this way
sum(Left)/(Sum(Closed)/12)
if its null value then didn't show to show 0 value
in presentation tab-->uncheck suppress zero value
Try like this
Sum(Left)/(Sum(Closed)/12)
or
column(1)/column(2)