changing the number decimals

[raadwiptec]

Hi all,

My report is having a distributed to each users. Here one of the users needs to have the access to properties to change the current number from 1.23 to 1.2333

As he is the only user who required the report in that way .rest of them should see the report as 1.23 only

How could I give him the access here?

[sunny_talwar]

May be using OSUser() function.

If(OSUser() = 'PersonX', Num(Sum(Value), '#,##0.0000'), Num(Sum(Value), '#,##0.00'))

[raadwiptec]

hi sunny is their a possibility the user could change the decimal places himself as a option to 1.23 or 1.2333 or 1.2344

[sunny_talwar]

Find attached a sample where a user can control the number of decimals using input box

Expression: =Num('1.2344', $(=Chr(39) & '#,##0.' & Repeat(0, vDeci) & Chr(39)))

[Gabriel]

Hi,

One thing I will like to add to excellent suggestion from Sunny T is you can customized the InputBox to this particular user. Go to Layout and have condition show to this user and only this user will have the ability to change the format.