Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i want to add some bucketing in my expression ..
This is my expression
SUM({$<FinancialYear=,Quarter=,MonthName=,[Date] ={"<=$(=MonthEnd(Max([Date])))"}>}[Sale])
And I want to add below condition in above expression
=if((num((num(vDateForAgeing)-[Post Date ]),'#######0') )<=180 ,'Below Six Month',
if(num((num(vDateForAgeing)-[Post Date ]),'#######0')>=180.1,'Above 181',
0))
Thanks
Hi All,
I need Bucket ageing sale for above 6 six month and Below Six month....
Thanks
I have created like this but i want in this as expression
Like in my one repression I want sum(sale) in 2nd expression sum(actual sale < 180 days ) and 3rd expression sum(actual Sale > 180 days)
Thanks