Epression

[aveeeeeee7en]

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??

[ashfaq_haseeb · Accepted solution]

Hi try below

4) Sum(Left)/(Sum(Closed)/12)   - It is Not Working & Not Giving Me the Result.

Hope it help.

Regards

ASHFAQ

[alexandros17]

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

[er_mohit]

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

[Anonymous]

Try like this

Sum(Left)/(Sum(Closed)/12)

or

column(1)/column(2)