Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

ADDING CURRENCY TO TITLE BASED ON PROMPTS

Received Response
1
Views
3
Comments
Igor1188
Igor1188 Rank 3 - Community Apprentice

How can I add CURRENCY SIGN TO TITLE BASED ON PROMPTS ?

LIKE THIS ONE : https://ibb.co/TMj5mXf  but it should changed by prompts to another currency also (like gbp)

Answers

  • ca$hmon3y
    ca$hmon3y Rank 3 - Community Apprentice

    I'm not able to view your link but I imagine I know what you're referencing. You have to define your prompt as a Presentation Variable (ex. PV_CURRENCY). When you are editing your graph's title, you will then reference the Presentation Variable in the Title (ex. Graph of Spending in @{PV_CURRENCY})

  • Igor1188
    Igor1188 Rank 3 - Community Apprentice

    Thanks!

    if I have : USD or EUR in prompt

    but I want to represent $ or

    how can I do it ?

  • Jerry Casey
    Jerry Casey Rank 6 - Analytics Lead

    I can't see your link, either.
    You can use a variable prompt, perhaps with radio buttons for USD or EUR. The choice will be a pres variable, say P_CURR.

    In your analysis, include a case statement column like CASE '@{P_CURR}{USD}' when 'USD' then '$' when 'EUR' then '€' , etc.

    Use a formatted narrative view for your title that references that column's position.

    In the narrative view, set the "number of rows to return" as 1.