Set analysis

[nareshthavidishetty]

Hi,

I have tried to calculate MTD value with the below expression but it is not working.

Expression: (count({<creation_date {">=$(=(vMstart)))<=$(=vYesterday))"},flag={'Non GUI'}>}distinct order_number))

Thanks..

[Anil_Babu_Samineni · Accepted solution]

May be this?

Count({<creation_date = {">=$(vMstart) <=$(vYesterday)"}, flag = {'Non GUI'}>} DISTINCT order_number)

If not post variables and flag in details

[jayanttibhe]

In addition to Anil;s response : You would also like to have no impact of another Calender fields in your MTD expression;

Just take care it within the set expression : Year=, Month=, Quarter=, Week=, DateField=,

etc.