ADDING CURRENCY TO TITLE BASED ON PROMPTS

Igor1188

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)

ca$hmon3y

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

Thanks!

if I have : USD or EUR in prompt

but I want to represent $ or €

how can I do it ?

Jerry Casey

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.