on 2020 May 07 4:08 PM
Hi All,
We are pulling data for certain accounts from another category using a formula in the category scenario. However we now need to make these accounts entry enabled for certain reporting units while other reporting units will continue to pull the data from another category. We are trying to do this by introducing a trigger condition in the existing formula as below
Formula expression-
{AC in AC1-001 ; FL = Y99} = {CA = ACT-XXX}
Trigger condition-
{RU in RU-SCOPE}
where RU-SCOPE is the reporting unit filter
However this trigger condition is shown as invalid. Is this due to only AC and FL dimensions being allowed in the trigger condition expression or am I missing something else? We also tried the below formula expression but even that shows up as invalid
{RU in RU-SCOPE; AC in AC1-001 ; FL = Y99} = {CA = ACT-XXX}
Any ideas on how we can make this formula applicable only to certain reporting units?
Regards,
Manas Phadke
Request clarification before answering.
Hello, can I have two trigger conditions? Here is an example of the formula and the two trigger conditions I would like to add:
Formula: {AC in (FAMREF=BL1-F0002) ; FL in (F20; F30; F40; F50; F60; F61; F62; F70)} = {DP = MONTH(-1; REF_PER) ; PE = MONTH(-1; REF_PER)}
Trigger conditions: [DP > DFIRST] AND [RU in (ETYPE=S)]
For your information, I tried to include the second condition ([RU in (ETYPE=S)]) in the formula, but it didn't work.
Thank you for helping me solve the issue
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
4 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.