Calculating fields with different tables

[viveksingh]

Hi Experts,

I Have CASE STATEMENT like below,

CASE WHEN "W_GL_ACCOUNTS_D"."GROUP_ACCOUNT_NUM"='CASH' THEN (CASE WHEN "BICS_GL_LEDGER_D_V"."LEDGER_CURRENCY"='GBP'

  THEN "W_GL_BALANCES_F"."BALANCE_LOC_AMOUNT"*1.24

  WHEN  "BICS_GL_LEDGER_D_V"."LEDGER_CURRENCY"='EUR'

  THEN "W_GL_BALANCES_F"."BALANCE_LOC_AMOUNT"*1.07

  ELSE "W_GL_BALANCES_F"."BALANCE_LOC_AMOUNT" END ) END CASH

Here, GROUP_ACCOUNT_NUM is from GROUP_ACCOUNT table

          LEDGER CURRENCY is from LEDGER Table

         BALANCE LOC AMOUNT is from BALANCE Table

can any one help in writing this in a simple way. without if statement.

Is this possible with the Mapping load ?

[german24]

Hi,

pelease upload a small sample qvw, without knowing your datamodel and fields it might be difficult to assist.

Regards,

German

[adamdavi3s]

Why is there a need to simplify this? It looks like good code to me ?