Hi All,
I want to remove if condition from below expression: Is it possible to reduce the below expression code.
IF(GetFieldSelections(Options1)='Millions',IF(GetFieldSelections(Options3)='No',Sum({<sub_account={'Expense'}>}cost_plus)/min(Options1), (Sum({<sub_account={'Expense'}>}cost_plus_ex_cc)/min(Options1)),
IF(GetFieldSelections(Options3)='No', Sum({<sub_account={'Expense'}>}cost_plus), Sum({<sub_account={'Expense'}>}cost_plus_ex_cc))),
IF(GetFieldSelections(Options1)='Millions', IF(GetFieldSelections(Options3) = 'No', SUM({<sub_account = {'Expense'}>}transfer_price)/min(Options1), (SUM({<sub_account = {'Expense'}>}transfer_price_ex_cc)/min(Options1)),
IF(GetFieldSelections(Options3)='No',sum({<sub_account = {'Expense'}>}transfer_price),sum({<sub_account = {'Expense'}>}transfer_price_ex_cc)))
Regards,
AK