Need help in writing expression.

[suvechha_b]

Help me in writing the following expression :

if (vAmountType)='Units' then

  [sum({<[Main Division Code Name]=>}sales_budget_units)]

{ elseif (vAmountType)='Value' then

[sum({<[Main Division Code Name]=>}sales_budget_units_value)]}

[ else

[0]]

end if

[tresesco · Accepted solution]

=if (vAmountType='Units' ,

  sum({<[Main Division Code Name]=>}sales_budget_units) ,

if (vAmountType='Value' ,

sum({<[Main Division Code Name]=>}sales_budget_units_value) ,0))

Note, your variable vAmountType might have to be expanded with '$' sign, like if($(vAmountType) ='Units'