Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one requirement, like ignore month and year filters for if condition expressions:
Expression:
IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({<Type={'1'}>}Volume),
Count({<B={'1'}>}ID))
Tried:
Solution 1:
IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({<Type={'1'},Year=,MonthName=>}Volume),
Count({<B={'1'},Year=,MonthName=>}ID))
Solution 2:
IF(WildMatch(MonYY,'*18','Jan-19'),
Sum({1<Type={'1'}>}Volume),
Count({1<B={'1'}>}ID))
but no luck
can any one let me know any solution for the same
Try this
If(WildMatch(Only({<Year, MonthName>} MonYY), '*18', 'Jan-19'), Sum({<Type = {'1'}, Year, MonthName>} Volume), Count({<B = {'1'}, Year, MonthName>}ID) )
Try this
If(WildMatch(Only({<Year, MonthName>} MonYY), '*18', 'Jan-19'), Sum({<Type = {'1'}, Year, MonthName>} Volume), Count({<B = {'1'}, Year, MonthName>}ID) )