Expression

[upaliwije]

Hi,

I have following Fields in my data model

PR_Month

PD_month

Amount

I have written following expression in my pivot table but it is not working

SUM(IF(PR_Month<PD_month ,PROVISION_AMOUNT))

Pls correct me if I have written above expression incorrectly

[settu_periasamy · Accepted solution]

Hi,

Try this

SUM({<PR_Month={"<$(=PD_month)"}>}PROVISION_AMOUNT)

[sunny_talwar]

Expression looks right to me. Create a table box with the three columns and see if the condition is ever true. If its not then you won't see any results.

[upaliwije]

THANKS

[kmswetha]

Hi Upali, Your expression looks good. did you check for syntax errors?