wtd Sales

[#1]

I  have written a expression so that sale quantity not  change week selection but still its keep on changing week selection

sum({<Year=,Num_Month=,NumWeekDay=, Week=,[Posting Date]=,Posting_Day=,PostingDateNum={'>=$(vMinDate_AMS11)<=$(vMaxDate111)'}>}[Sale Quantity]))

What wrong in this expression

[robert_mika]

maybe:

sum({<Year=,Num_Month=,NumWeekDay=, Week= ,Posting_Day=,PostingDateNum={'>=$(vMinDate_AMS11)<=$(vMaxDate111)'}>}[Sale Quantity]))

[#3]

no

[jagan]

Hi,

Check your variables are changing based on the selection, if variables change the values of the expression will also change.

sum({<Year=,Num_Month=,NumWeekDay=, Week=,[Posting Date]=,Posting_Day=,PostingDateNum={'>=$(=vMinDate_AMS11)<=$(=vMaxDate111)'}>}[Sale Quantity]))

Can you attach the sample file?

Regards,

Jagan.

[#5]

vMinDate_AMS=

num(date(AddMonths((vMaxDate)+1,-12),'DD/MM/YYYY'))

vMaxDate111

num(date(max([Posting Date]),'DD/MM/YYYY'))

[#6]

vMaxDate=

date(max([Posting Date]),'DD/MM/YYYY')

vMinDate_AMS=

num(date(AddMonths((vMaxDate)+1,-12),'DD/MM/YYYY'))

vMaxDate111

num(date(max([Posting Date]),'DD/MM/YYYY'))

[#7]

where VminDate_AMs  used for calculating last 12 months data

[Kushal_Chawda]

I think in variable $(vMaxDate111) you have to change the expression.

I am assuming you have expression as max(Date), so you can write expression as  max({<Week>}Date)

[sasiparupudi1]

Make sure that you have the date in PostingDateNum  the format same as in your variables