need help??

[paulwalker]

Hi Community,

how to calculate MTD and YTD

MTD:

=Sum({<[Posting Date]={'>=$(=MonthStart(Today()))<=$(=Today())'}>} CLE_Amount)

i am using this expression.. but unable to get values..

Please anyone can help me.....

[alexandros17]

Sum({<[Posting Date]={'$(>=MonthStart(Today())<=Today())'}>} CLE_Amount)

the $(= ... must be applied to the whole sub expression

let me know

[antoniotiman]

Hi Paul,

format of Posting Date is DD-MM-YYYY, but in script your DateFormat is D/M/YYYY

You can try

....$(=Date(MonthStart(Today()),'DD-MM-YYYY')))

also in $(=Today())

Regards,
Antonio

[paulwalker]

Hi ,

Still i am unable to get values...

[jyothish8807]

Hi Paul,

try like this:

SUM({<Date = , Month =, Quarter = , Date = {">=$(=MonthStart(Today()))<=$(=Today())"}>}Sales) 

will give you Total Sales for Current Month to Date 

SUM({<Date = , Month =, Quarter = , Date = {">=$(=YearStart(Today()))<=$(=Today())"}>}Sales) 

will give you Total Sales For Current Year to Date 

Regards

KC

[antoniotiman]

See Attachment

[maxgro]

it seems you have different format for the dates, in dimension and in set analysis expression

try with

=Sum({<[Posting Date]={">=$(=date(MonthStart(Today()),'MM-DD-YYYY'))<=$(=date(Today(),'MM-DD-YYYY'))"}>} CLE_Amount)