# Very urgent ---- Formula assistance needed

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.

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

Thanks @Akhtar.shahbaz for your detail screenshot.

But in my case, for Module 1, Products are Text formatted (as it is from Hub).

So in that case, can I change it to List format?

Just add one more line item and find the product type using FINDITEM formula then proceed futher with the same approach.

Hope this helps!

thanks

Akhtar

•

You are so very close to the answer!  You will indeed want to leverage the SUM function here.  In order to do this you will need to reference the count line as the column holding the values to be summed and the Products line item as the column to cross reference.  In common language, this would take each product in the target module (Cars Mod 2) and if the product matches in the source module (DH Mod 1) it includes that count in the summation.

http://help.anaplan.com/anapedia/Content/Calculation_Functions/All/SUM.html

Let me know if you need any more help.  🙂

-Tiffany

• Thanks @Tiffany.Rice.

I really need help.

As dimension is not same in both the module, having Cities extra.

How will I be able to do so?

• Thanks @Akhtar.shahbaz for your tireless selfless help.