% display in SAC table

[f_allocca]

Hi Experts,

on SAC I created a calculated indicator, the %GrandTotal().

When viewing the % in the table, SAC puts the '+' sign before the number.

How can I eliminate this sign (+0.30%) from my percentage?

I would just like the number (0.30%).

Best Regards.

Francesco

[murllimaraati]

Go to Edit formating for that measure and then follow below steps

1. Uncheck Use number formatting of Account dimension

2 - make sure Show Sign As - Default.

This will solve your issue.

[f_allocca]

Hi,

thanks for replying;

but I don't have the option to choose the option you suggested.

I'll attach my screen to you.

[murllimaraati]

Interesting. I assume you have created a calculated measure. Is there any way we can connect ? Murlli Maraati

[hyderali_kharodia]

Hi,

After obtaining the formatting box, it should appear by default as shown below. In this case, the 'Percentage' option is grayed out.

Now, uncheck the 'Use unit of underlying measures' option. The resulting screen below allows you to select 'Percentage'.

[f_allocca]

HI.

Thanks a lot for the answer.

I used grandtotal in the formula, and it doesn't allow me to change the formatting.