Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
LYTD-mean last year to till date (or)
last year same months comparision with this year months
plase reply some one
Thanks In Advance
Niranjan
See this blog post: Year-over-Year Comparisons
You will need to use SET ANALYSIS (lots of help documentation on that) it allows you to specifiy different valutes than what the user has selected.
Imagine if your application has a field called START_Y that the user clicks and it they click 2013. This set analysis expression would change the formula to use the previous year, 2012 instead of 2013.
=SUM({$<START_Y={$(=Only(START_Y)-1)}>FieldYouWantSummedUp) |
You need to use your own FIELD names for Year and for whatever figure you are tryingt to sum up
Hi Gysbert,
please give me one word answer simple way
What is LYTD
Regards,
Niranjan
Yes LYTD means Last Year To Date.
So if the user clicked and chose February 2014 and you showed those numbers. LYTD would mean you should show them the sum of the data for 2013 up to and including February. Typically it is only regarding months but you could do the same to an actual date like today.