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

[Anonymous]

DO you need the Day function Sunny. Wouldn't this work,

(Sum({<[Reported Date]={'>=$(vYTDstart)<=$(vYTDend)'}>*<[Reported Date] = {"=MonthEnd([Reported Date])"}>} TOTAL [Margin Dollars])

    /

    Sum({<[Reported Date]={'>=$(vYTDstart)<=$(vYTDend)'}>*<[Reported Date] = {"=MonthEnd([Reported Date])"}>}TOTAL [Margin Booked Sales]))

[sunny_talwar]

I don't think so... but I may be wrong