SAC show only positive values

[former_member302630]

Hi,

SAC live connection on S/4 CDS views.

There is table in a story on which I want to show measures only if they are greater than zero.

I don't see the advanced filter option. Any other options?

It cannot be a page condition because there are other widgets on this page that should not follow this 'greater than equal to zero' rule.

Regards,

Cleo

[avsalynin]

cleo.james

you can add such a simple formula - IF(measure>=0;1;0)

then filter in the added column only by value 1 (via the context menu - filter)

then hide this column

[former_member302630]

Hi,

How do we build a calculated measure that does NOT contain a row for lesser than zero?

If I use an 'if', I still have to provide a condition false result which comes as a row.

The requirement we have is a table that should display ONLY positive values and zero.

Regards,

Cleo

[former_member757949]

Hi Cleo,

I know it's been a while but did you find a solution to your problem? We are currently facing the same...

Regards,

Jonas

[William_Yu]

Hi cleo.james,

You probably can try to create a calculated measure on your measure.

Best regards, William