Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be using OSUser() function.
If(OSUser() = 'PersonX', Num(Sum(Value), '#,##0.0000'), Num(Sum(Value), '#,##0.00'))
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
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)))
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.