Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used the below logic in my chart expression.
(sum({<[Reported Date]={'>=$(vYTDstart)<=$(vYTDend)'}>} TOTAL [Margin Dollars])
/
sum({<[Reported Date]={'>=$(vYTDstart)<=$(vYTDend)'}>}TOTAL [Margin Booked Sales]))
Here i need to capture only the month end value starting from Feb,2016.
vYTDstart = 02/01/2016
vYTDend=today()-1
Thanks..
What is the meaning of
Here i need to capture only the month end value starting from Feb,2016.
do you mean last day of month ?
What are you getting today? I mean what is wrong with the expression you have given above? Not working? Giving wrong results?
Hello nareshthavidishetty,
Could you please elaborate more? This will help us to further analyze this issue.
Regards!
Rahul
Do you want your expression to only consider the last day of each month?
i.e values only for these dates:
29/02/2016
31/03/2016
30/04/2016
31/05/2016
30/06/2016
31/07/2016
31/08/2016
30/09/2016
31/10/2016
30/11/2016
31/12/2016
31/01/2017
?
Hi,
By default backend values are MTD. I need to get YTD numbers for that if do calculation as
YTD =sum(MTD) which is not correct.
So i need to pick only the monthend numbers stating from Feb 2016.
Thanks..
May be this:
(Sum({<[Reported Date]={'>=$(vYTDstart)<=$(vYTDend)'}>*<[Reported Date] = {"=Day([Reported Date]) = Day(MonthEnd([Reported Date]))"}>} TOTAL [Margin Dollars])
/
Sum({<[Reported Date]={'>=$(vYTDstart)<=$(vYTDend)'}>*<[Reported Date] = {"=Day([Reported Date]) = Day(MonthEnd([Reported Date]))"}>}TOTAL [Margin Booked Sales]))
Hi Sunny ,
Just out of curiosity, you are doing intersection here so it will consider the YTD end as the Month end ?
I could understand the expression partially. Could you say how it functions?
Regards,
Balakrishnan. R
Yup,
Look for YTD, but only those Reported Dates which belong to the end of the month dates