Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
May be this?
Count({<creation_date = {">=$(vMstart) <=$(vYesterday)"}, flag = {'Non GUI'}>} DISTINCT order_number)
If not post variables and flag in details
May be this?
Count({<creation_date = {">=$(vMstart) <=$(vYesterday)"}, flag = {'Non GUI'}>} DISTINCT order_number)
If not post variables and flag in details
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.