Null issue in Set analysis

agastya — Wed, 21 Jul 2021 09:19:19 GMT

Hello Team ,

Expression : Variable column Expression

IF($(vAfterRev) >1,
Count(TOTAL<ss>{$<ss,OrderYear=,OrderMonth=,MonthYear = {"$(='>=' & Date(MonthStart(Max(MonthYear), -12), 'MMM-YYYY') & '<=' & Date(Max(MonthYear)-1,'MMM-YYYY'))"}>} DISTINCT ss))

I want to exclude '-' from total counts but not sure if anything wrong in expression, expected value is sum of the column,

variable column 8 including Null values as well ,Count are based on last column greater then 1 then only there should be value variable column I.e 4

Ouput Table:

|Column 1|Variable |

|Eue | 4|

@sunny_talwar

topic Null issue in Set analysis in App Development

Null issue in Set analysis