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