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
Oh, Are you sure about AddYear function???
Try this
Sum({$<Nature={'Actual},[Fiscal Year]=, month=,
DateNum={">=$(=Num(YearStart(Max(DateNum),-1)))<=$(=Num(AddMonths(max(DateNum), -12 )))"}>}
Amount)
Hi,
Smth wrong in your >= <= logic I suppose.
Sum({$<Nature={'Actual},[Fiscal Year]=, month=, DateNum={">=$(=Num(YearStart(Max(DateNum),-1)))>=$(=AddYear(max(DateNum), -1 ))"}>}Amount)
Please check it.
Hope this helps.
Andrei
Sum({$<
Nature={'Actual},
[Fiscal Year]=,
month=,
DateNum= {“$(=Num(YearStart(Max(DateNum)),-1))<=$(=AddYear(Max(DateNum),-1))”}Amount)
This is the formula of this post with the Appendix Nature={'Actual'}
I Shows only 0 and no values.
Can give me hint why?
this code Show nothings no figure only a space.
Do you have a other question?
Yes, Provide sample data 🙂
Oh, Are you sure about AddYear function???
Try this
Sum({$<Nature={'Actual},[Fiscal Year]=, month=,
DateNum={">=$(=Num(YearStart(Max(DateNum),-1)))<=$(=Num(AddMonths(max(DateNum), -12 )))"}>}
Amount)
What do you mean with sample data? The structure of the table?