Set analysis

[nareshthavidishetty]

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..

[MK_QSL]

What is the meaning of

Here i need to capture only the month end value starting from Feb,2016.

[dsharmaqv]

do you mean last day of month ?

[sunny_talwar]

What are you getting today? I mean what is wrong with the expression you have given above? Not working? Giving wrong results?

[rahulpawarb]

Hello nareshthavidishetty,

Could you please elaborate more? This will help us to further analyze this issue.

Regards!

Rahul

[Anonymous]

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

?

[nareshthavidishetty]

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..

[sunny_talwar]

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]))

[#9]

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

[sunny_talwar]

Yup,

Look for YTD, but only those Reported Dates which belong to the end of the month dates