Community Boss

## 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.

3 ACCEPTED SOLUTIONS

Accepted Solutions
Community Boss

## Re: Formula assistance needed

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

Community Boss

## Re: Formula assistance needed

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?

Community Boss

## Re: Formula assistance needed

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

6 REPLIES 6
Certified Master Anaplanner

## Re: Formula assistance needed

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

Community Boss

## Re: Formula assistance needed

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?

Community Boss

## Re: Formula assistance needed

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

Community Boss

## Re: Formula assistance needed

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?

Community Boss

## Re: Formula assistance needed

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

Community Boss

## Re: Formula assistance needed

Thanks @Akhtar.shahbaz for your tireless selfless help.