Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello togehter,
I have a YTD Formula (it Shows the right figures)
Sum({$<Nature={'Actual'},[Fiscal Year]=, month=, DateNum={">=$(Num(YearStart(Max(DateNum))))<=$(=(Max(DateNum)))"}>} Amount)
this formula Shows the wrong figures
Sum({$<Nature={'Actual},[Fiscal Year]=, month=, DateNum={">=$(=Num(YearStart(Max(DateNum),-1)))>=$(=AddYear(max(DateNum), -1 ))"}>}Amount)
Do you know why? and could help me.
Thanks
Sum({$<
Nature={'Actual},
[Fiscal Year]=,
month=,
DateNum= {“>=$(=Num(YearStart(Max(DateNum)),-1))<=$(=AddYear(Max(DateNum),-1))”}Amount)