Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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'))
That's sounds somewhat familiar, but could be unrelated. Can you post a sample document?
Hi,
Make sure that for those figures which are showing in percentages, not having the metrics_Number_or_percent = 'PERCENT' value.
Regards,
Kaushik Solanki
Hi,
try this one....
=If(metrics_Number_or_percent='PERCENT',num(metrics_target,'#,##0%'),num(metrics_target,'#,##0')),
metrics_Number_or_percent)
Many thanks for your reply,
Please find attached an example file of what I am trying to achieve.
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'))
Hi Gysbert,
That has worked. Many thanks for your help.