Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am having issues with the following if statement:
What am I doing wrong here ? I need to expand: Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') on a Dim.
IF(MonthOfService >= $(=Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') ),MonthOfService , Null() )
I've also tried:
IF(MonthOfService >= Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') ,MonthOfService , Null() )
but no luck.
Hi Val,
Create variable of Date(AddMonths(Max(MonthOfService), -13), 'YYYY-MM') and use that in Expression. May be that help.
Try this:
If(MonthOfService >= Date(AddMonths(Max(TOTAL MonthOfService), -13), 'YYYY-MM'), MonthOfService, Null())