SAP SAC IF function parameters

[#1]

Greetings to Everyone,

I am genuinely new in the world of SAC. I am facing the following problem.

Feel free to suggest any solution.

Thank you in advance,

Chris Andreou

[N1kh1l]

chrissoftinent

This is expected behaviour in SAC. What you are doing is a calculated measure (numeric calculation) so you cannot have string values as parameters in IF in calculated measure. But to achieve the above you can follow a trick. You can replace "Overdue" with 1 and "Open" with 0. Then use Measure based dimension (calculated dimension ) and assign 1 as "Overdue" and 0 as "Open"

Please accept /upvote if this helps.

Nikhil