Need help in Set expression

[#1]

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

[tresesco]

Could you post a demonstrative sample? Preparing examples for Upload - Reduction and Data Scrambling