cancel
Showing results for 
Search instead for 
Did you mean: 

BFC: Trigger condition in formula based on RU?

phadke_manas
Participant
0 Kudos
222

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

View Entire Topic
NIM1
Newcomer
0 Kudos

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