Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
in number select percentage
num(Floor(Return,0.01), '# ##0.00%')
maybe this helps
The dimension does not appear in Number.
Joao
Sent from my iPad
Go to Chart properties --> Dimensions --> Add 'Return' as Dimension and then Edit to make it
=num(Floor(Return,0.01),'###0.00%')
Regards
Raj