How to calculate sales and bring forward some dates sales to next month?

[jim_chan]

Hi guys,

I need to create a monthly Sales  expression.

The requirement here is:

Sales ID with Good Issue dates that fall on 28,29,30,31 and Sales_cat = M, I . will be added in to Next Month Sales.

I have a sample attached here.

Rgds,

Jim

[jim_chan]

Dear Varun,

The Month: should use Sales_Date. i use this as calendar the calendar date. So it should be 2 months - Oct and Nov.

The Figure: Correct 90 and 190.

the scripting that i plan to create at the front UI for the Sales Volume as at Yesterday is:

sum({<Month =,Year ={$(vLatestYear)},Date={">=$(vMin)<=$(vMax)"}>}Sales)

So, i wanted to add ur condition in the loading script and AS Sales. and use it at the front.

Rgds

Jim