SAP SAC IF function parameters

[ChristosAndreou]

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

[vitran23]

Are you doing this in AA or inside a story?

[Pooja_Elangovan1999]

Hello Christos Andreou,

Please try changing the column to a number in the model creation phase before using it in a formula and make sure whether you have defined measures and dimensions correctly while creating the model.

Thanks,

Pooja.