BFC: Trigger condition in formula based on RU?

[phadke_manas]

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

[Olga_Vasileva · Accepted solution]

Hello phadke_manas,

Try changing syntax for the trigger condition a bit: [RU in RU-SCOPE]

[phadke_manas · Accepted solution]

Thanks for your prompt reply Olga. Really surprising the FC 10.0 User Guide doesn't specify this syntax in the section on the category scenario formulae.