Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 213 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OTBI formula based on presentation variable prompt
User_527SY
Rank 2 - Community Beginner
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 :
1