Text Box Calculation

[kevbrown]

I have a text box with a calculation that is looking at a precentage. I would like that percentrage at 2 decimal places and not he10 it currently is, how do i limit it to 2 decimal places?

Thanks

[alexandros17]

Write:

Num(myexpression, '#.##0,00 ')

hope it helps

[morganaaron · Accepted solution]

Hi Kevin,

Wrap it in a num statement and specify the number of DP's:

So Num([Your Expression], '###.##%')

[krishna20]

Hi,

Goto Number tab-> select Fixed to 2 decimals and enable show in Percent.

Regards

Krishna

[kevbrown]

Thank you