Set Expression in if statement

Seb_Sanders — Mon, 20 Dec 2021 21:02:46 GMT

I've built sheets for each product line that contain a pivot table. Each measure contains something alone the lines of :

Count({<Species={Dog}>}Policy_No)

This has meant I have identical sheets for each "Species" with the same measures, exactly what I was after. However, I need to blank out the latest date in the pivot table.

I have an IF statement to identify this line, something like:

If ( LatestMonth = 'Y' , 0 , Count({<Species={Dog}>}Policy_No) )

This then brings back all the other "Species" lines that were previously hidden.

Firstly, how do I stop this?

Secondly, can I return a blank / null value instead of 0 if the condition is true?

Thanks

Re: Set Expression in if statement

marcus_sommer — Thu, 01 Apr 2021 09:59:42 GMT

Maybe in this way: Count({<Species={Dog}, LatestMonth = {'Y'}>} Policy_No)

- Marcus

topic Re: Set Expression in if statement in App Development

Set Expression in if statement

Re: Set Expression in if statement