OTBI formula based on presentation variable prompt

User_527SY

Hi,

I have tried to create report and in the fact amount using the following formula

"CASE WHEN "Ledger"."Ledger Name" = @{COMPANYA} THEN 1 WHEN "Ledger"."Ledger Name" = @{COMPANYB} THEN 2   ELSE "Balances"."Ending Balance" END"

And created presentation variable prompt ,my problem that above not captured the "Case" just bring me the "ELSE "Balances"."Ending Balance" END",could

I am expecting to have "1" or "2" based on the ledger.

Could you please advice?

Prompt definitions :

The formula :