transformation and formula challenge

[pangersandmash]

Hello

I am stuck on a problem- wondering if anyone can help please.

I basically want to write a rule that says 'when an invoice has FTA, PUBINS, and PCCR, allocate the full amount to PUBINS'.

But, only for these 3. The screenshot below should help.

I tried to use a cross tab tool so i have something like the below

but i couldn't get any further. Any advice?

Thanks

[TheOC]

hey @pangersandmash 

Glad i could help!

Cheers,
TheOC