Showing results for 
Search instead for 
Did you mean: 

Fox logic in BPC embedded planning

0 Kudos

Hello Experts,

Need help in fox logic to write data if there is no data exist already in the output.

Source data:

data to multiply: (data is available with below 4 common dimensions to multiply with all different partner objects).

final output:

My fox as below:

And it is working fine if we already have some data in the final output combination. if there is no data in the final output combination then, logic is not generating new records.

any help is much appreciated.

Thanks in advance,

Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos


you have the record with 100 CAD and Partner #.

Loop over this record.

Inside this loop, you should use a nested loop over FTE and Partner.

In the nested loop, you can create the new records based on the outer loop with the partner from the inner loop.