How do I format the number format of a dimension (not expression)?

[Anonymous]

Hi

This is a really simple question that I'm hoping has a really simple answer. Any help would be greatly appreciated.

I'm plotting a histogram of returns using Floor(Return,0.01) as my dimension and Count(Return) as my expression. It works perfectly, but I would like the x-axis formatted as %. I can't find anywhere to do this.

Thanks.

Joao.

[Anonymous]

in number select percentage

[giakoum · Accepted solution]

num(Floor(Return,0.01), '# ##0.00%')

maybe this helps

[Anonymous]

The dimension does not appear in Number.

Joao

Sent from my iPad

[#5]

Go to Chart properties --> Dimensions --> Add 'Return' as Dimension and then Edit to make it

=num(Floor(Return,0.01),'###0.00%')

Regards

Raj

[Anonymous]

This is exactly what I needed.

Thank you.

Kind regards,

Joao Frasco

Chief Investment Officer

T +27 11 448 6983

F +27 11 448 6526

C +27 71 887 7698

W www.stanlib.com<http://www.stanlib.com/>

17 Melrose Boulevard

Melrose Arch, 2196

Johannesburg, South Africa

PO Box 202

Melrose Arch, 2076

Johannesburg, South Africa