topic Can we calculate field value based on Access type ? in App Development

Can we calculate field value based on Access type ?

SRT10 — Wed, 08 Dec 2021 08:45:21 GMT

We gave field Revenue. There are 2 types of Revenue i.e. 1.Local Revenue 2. Global Revenue
Revenue = Local Revenue + Global Revenue

Local User is not allowed to see Global Revenue. So we have 2 situations like below -

1. If there is a user who has access to Local level,
We need to show only Local Revenue in Revenue column

2. If there is a user who has access to Global level,
We need to show Local Revenue + Global Revenue in Revenue column

Revenue column is viewed in various tabs of dashboards.
is there any solution to handle this ?
Can we have some logic or set analysis when dashboard is refreshed and derive data based on access sheet.

Re: Can we calculate field value based on Access type ?

anat — Wed, 08 Dec 2021 09:52:55 GMT

in section access create a flag like "local level" is 1 and global level is 0

create 2 expressions and show based on the conditional

Re: Can we calculate field value based on Access type ?

SRT10 — Wed, 08 Dec 2021 11:14:23 GMT

you mean use if condition in chart properties/expressions ?

Is it good to use if there..