Very urgent ---- Formula assistance needed

Sravan_Kumar

Module 1: I have a Transaction List and the Employees responsible for the Sales.

 

Module 2: These are 3 types of Cars of different cities Commission percentage.

 

Module 3: Now the challenge is I have to make a new module with Employee and Commission. But the data should be flowing from Module 1 by ‘Connect to Anaplan Model’.

I have provided how Module 3 (Calc) 2 will look like.

I think Sum Function will be helpful initially but not aware how to write the formula of reference in Anaplan.

 

Kindly guide me on this Community Friends.

 

Mod1_65988.PNG

Mod_1_(A)_65988.PNG

Mod_2_65988.PNG

Calc_(1)_65988.PNG

Calc_(2)_65988.PNG

Akhtar.shahbaz

Hi @Sravan_Kumar 

 

I have tried to replicate your problem and calculation.

 

1. Create a system module to input the product count

 

2. Create one calculation module to sum count of product.

 

3. Create another module by Car type and location and one line item for input the percentage

 

 

Hope this helps!

Thanks

Akhtar