Skip to Content
0
Dec 16, 2020 at 07:39 AM

IF formula on Parent GLs in BPC

27 Views Last edit Dec 16, 2020 at 09:11 AM 2 rev

Hello

We have 2 parent GLs A01 A02, in APL_ACCOUNT dimension which have more than 5 base GLs each in their grouping and A03 and A04 are base Gls. We want to include a logic where if sum of base GLs of A01 > 0 then show the sum total value in A03 GL else show value as 0. Similarly if sum of base GLs of A02 > 0 then show the sum total value in A04 GL else show value as 0.

Implementing this in member formula will not be feasible. If I have to include this in logic script then how do I handle IF condition. Please suggest.

Regards

Neha