Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a text box that contains an expression, however i dont want it to be affected by the selections in the list boxes.
=SUM(IF( (date(Monthname(C_DATE),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0))
This?
=Sum({1} If((Date(Monthname(C_DATE), 'MMM-YY')) >=(AddMonths(Today(),-12)), 1, 0))
Try this:
=Sum({1}IF((Date(Monthname(Only({1}C_DATE)),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0))
This?
=Sum({1} If((Date(Monthname(C_DATE), 'MMM-YY')) >=(AddMonths(Today(),-12)), 1, 0))
Did you try something like:
=SUM({1}IF( (date(Monthname(C_DATE),'MMM-YY')) >=(AddMonths(Today(),-12)),1,0))
sunindia The original expressions works fine for me; two other expressions are returning errors regarding nested aggregation (I would assume that might be coming from num() function)
matthewp - can you please confirm what was the result of your original expression?