Calculated Dimension help

[jarrad_murray]

Hi All,

I have an if statement with an embedded number function to display a dimension as either an integer or a percentage.  The code that I am using for this is =if(metrics_Number_or_percent='PERCENT',num(metrics_target,'#,##0%'),num(metrics_target,'#,##0')).

The problem that I am facing is that a couple of the figures that should be coming out as numbers are coming through as percentages.

Does anyone know if I am doing something wrong and/or how to fix this.

Many thanks

[Gysbert_Wassenaar]

That's sounds somewhat familiar, but could be unrelated. Can you post a sample document?

[kaushiknsolanki]

Hi,

     Make sure that for those figures which are showing in percentages, not having the metrics_Number_or_percent = 'PERCENT' value.

Regards,

Kaushik Solanki

[rathnam_qv]

Hi,

try this one....

=If(metrics_Number_or_percent='PERCENT',num(metrics_target,'#,##0%'),num(metrics_target,'#,##0')),

metrics_Number_or_percent)

[jarrad_murray]

Many thanks for your reply,

Please find attached an example file of what I am trying to achieve.

[Gysbert_Wassenaar · Accepted solution]

Probably a bug. Try as a workaround adding a small fraction:

=if(metrics_Number_or_percent='PERCENT',num(metrics_target,'#,##0%'),num(metrics_target+0.00000000001,'#,##0'))

[jarrad_murray]

Hi Gysbert,

That has worked. Many thanks for your help.