Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to sum all last year.what should i do.
What do you mean by all last year... What you want to sum ? please explain in brief.... Thnx
Please give the community more information on where, with what variables etc.... If you are too general, no-one will be able to help you in a fast and correct manner.
I would flag the last year in the script itself and use that within the set analysis to calculate the sum for last year:
=Sum({<LastYearFlag = {'Y'}>} Value)
HTH
Best,
S
Hi Chat,
not too much information, please. That would make it too easy for anyone to help 😉
Do you want to do that in the script or on the GUI?
Basically, in the script you can do that in an aggregation. On the GUI, you can use Set_analysis.
Best regards,
DataNibbler
I have some item. Ex item 1033.I want to some QTY every last year until now.Please.
SUM({<Year = {'$(=Year(Today()-1)'}>}Qty)
particular for item 1033
SUM({<Item = {'1033'},Year = {'$(=Year(Today()-1)'}>}Qty)
For this year...use
SUM({<Year = {'$(=Year(Today()))'}>}QTY)
Do you have a sampe of the data, and possibly a dummy of what you'd like to achieve with it?
i use this
sum( {$<IvAndTar_YearINVOICEDATE={'$(Y1)'} >} IvAndTar_IV_QTY )
Y1==date(AddYears(date#(IvAndTar_YearINVOICEDATE,'YYYY'),-1),'YYYY')
that code just sum last one year can you suggest me how can i sum all last year.