Need help in Set expression

Fri, 26 Aug 2016 05:22:48 GMT

Dear all,

Need help in set analysis expression,

Below expression working fine by item wise But Total level coming wrong.

Please help me on below .

(if([Base Unit]<> Confirmation_Unit, if(isnull(Conv), (sum({<FiscalYear={$(=max(FiscalYear))},

Date={">=$(=Date(monthstart(max({<Flag={'Actual'}>}Date))))<=$(=date(max({<Flag={'Actual'}>}Date)))"}>}[Rejected Quantity])),

( sum({<FiscalYear={$(=max(FiscalYear))},

Date={">=$(=Date(monthstart(max({<Flag={'Actual'}>}Date))))<=$(=date(max({<Flag={'Actual'}>}Date)))"}>}[Rejected Quantity])*Conv)),

sum({<FiscalYear={$(=max(FiscalYear))},

Date={">=$(=Date(monthstart(max({<Flag={'Actual'}>}Date))))<=$(=date(max({<Flag={'Actual'}>}Date)))"}>}[Rejected Quantity]) ))

Thanks,

Surender

Re: Need help in Set expression

tresB — Fri, 26 Aug 2016 06:12:36 GMT