Hello Pigment Community,
I just want one option to be marked, if suppose Absolute is checked, then the other options (Percentage and fixed) cannot be checked. How can I do this?

Please kindly guide me to perform this operation. Thanks a lot!
Hello Pigment Community,
I just want one option to be marked, if suppose Absolute is checked, then the other options (Percentage and fixed) cannot be checked. How can I do this?

Please kindly guide me to perform this operation. Thanks a lot!
Hi
To achieve your goal, you will need to leverage Access Rights (AR). Here's a step-by-step guide:
You can use the ACCESSRIGHTS function with the following formula:
ACCESSRIGHTS(true[ADD: User,Options] , 'Radio button T/F'[ADD: User])TRUE for all users.'Radio button T/F', dimensioned by your Options dimension. Use the formula:IF(
'Radio button selection'[REMOVE ANY: Options] = FALSE OR
ISBLANK('Radio button selection'[REMOVE ANY: Options]),
true[ADD: Options],
'Radio button selection'
)This formula checks two conditions:
FALSE value: 'Radio button selection'[REMOVE ANY: Options] = FALSE ISBLANK('Radio button selection'[REMOVE ANY: Options])
If either of these conditions is TRUE, write access is allowed for all options :

the AR metric would be:

.Otherwise, write access is granted only for the selected option.

The AR metric would be:

Once configured, apply the AR metric in the Data Access Rights section.

For more information on implementing AR, refer to:
Create an Access Rights Metrics and Rules
Hope this helps,
Issam
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.