1 2 Previous Next 17 Replies Latest reply on Sep 6, 2018 12:20 PM by suvas.chandra

# \$ and % sign

I have a formula like this:

If [Parameters].[Y-Axis] = "Commitment Amount" Then RUNNING_SUM(SUM([Commitment Amount]))

ELSE RUNNING_SUM(SUM([Commitment Amount]))/ATTR([BR Fund Size (LP Commitments]) * 100

END

This is my Y- Axis formula. Now, I want to populate \$ sign for Commitment Amount and % sign for the other. How do I do it ?

• ###### 1. Re: \$ and % sign

Hey Suvas,

Have a look at this blog and workbook - I think it will help?

http://www.vizwiz.com/2015/01/manyformats.html

• ###### 2. Re: \$ and % sign

You could wrap each part in STR (string) and then add the respective symbol.

• ###### 3. Re: \$ and % sign

Ravi,

It doesn't tell anything about the signs.

Suvas

• ###### 4. Re: \$ and % sign

John,

Can you please show me an example ?

Suvas

• ###### 5. Re: \$ and % sign

HI,

You can try below

If [Parameters].[Y-Axis] = "Commitment Amount" Then  STR(RUNNING_SUM(SUM([Commitment Amount])))+"\$"

ELSE  STR(RUNNING_SUM(SUM([Commitment Amount]))/ATTR([BR Fund Size (LP Commitments]) * 100)+"%"

END

• ###### 6. Re: \$ and % sign

Tried this?

If [Parameters].[Y-Axis] = "Commitment Amount" Then str(RUNNING_SUM(SUM([Commitment Amount])))+"\$"

ELSE  str(RUNNING_SUM(SUM([Commitment Amount]))/ATTR([BR Fund Size (LP Commitments]) * 100)+"%"

END

• ###### 7. Re: \$ and % sign

Hi, Suvas

below is the screenshot of the calculation fields

Hope this helps

ZZ

• ###### 8. Re: \$ and % sign

Attached 10.1 Example workbook.

• ###### 9. Re: \$ and % sign

John,

I am creating line charts. This should represent Y-Axis or Rows. In you case, it converts to discrete. But it has to be continuous in my case. It should also be controlled by the parameter. I could not do it.

Suvas

• ###### 10. Re: \$ and % sign

Tried long back. I need it continuous. It cannot be discrete.

• ###### 11. Re: \$ and % sign

Zhouyi,

What will you place in Row shelf ? I am creating line charts.

Suvas

• ###### 12. Re: \$ and % sign

Hi, Suvas

Is this what you mean? I use dual axis

ZZ

• ###### 13. Re: \$ and % sign

Zhouyi,

You cannot make dual. But I have used your concept and created this two formula and placed them on text:

If [Label] = "ON" AND [Parameters].[Y-Axis] = "Commitment Amount" THEN RUNNING_SUM(SUM([Commitment Amount]))

END

If

[Label] = "ON" AND [Parameters].[Y-Axis] = "Percentage" THEN RUNNING_SUM(SUM([Commitment Amount]))/ATTR([BR Fund Size (LP Commitments]) * 100

END

I also changed their data type. It works but it does not change the Y-Axis sign.

Need a good solution.

• ###### 14. Re: \$ and % sign

Suvas, Can you keep your existing calculation as is for the axis but for labels, use the String calculation Meena and Chaperi suggested?

so, you would use continuous axis for the visualization and discrete field for the labels.

1 2 Previous Next