Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have two fields selectors: month and day,
what I need is to go back one year even if I select day or month, I've tried something like this:
if(isnull(getfieldselections(day))='-1',
Sum ({<month={"$(=date(addyears(only(month),-1)))"}>}IMP_DESC),
Sum ({<day={"$(=date(addyears(only(day),-1)))"}>}IMP_DESC))
But it doesn't work if both fields are selected, I need to use the day selection in that case,
any idea?
OK,
I have to exclude mes_any field...