Combing 2 input values under one column

Hi,

I would like to add up the 2 input values from "Sales" and "Marketing" into the new column called "Sales and Marketing".

The reason is because there has been a change in the categories of business and the previously separated "Sales" and "Marketing" are now combined as one single category "Sales and Marketing".

Is there a way to add up the 2 figures whilst still maintaining the "input" functionality of the cell? It would not be a ideal situation if I would need to have the users re-enter the values under the new column?

Thanks.

Accepted answers

All comments

anand.shekhawat

@DarrenS

You cannot make the line item to be driven by a formula and simultaneously be a input field.

To achieve this functionality you can create two more line items and use the override method.

So it will go something like shown below.

I hope it helps

~Anand

MarkWarren

You want to retain the ability to enter data manually in "Sales and Marketing"?
You would need to create a line item to add the two values together and import into that line item. I'd advise against that though, avoid imports where possible.

Instead have an override line item, so "Sales and Marketing" would be something like:
IF Sales and Marketing Override? THEN Sales and Marketing Override value ELSE Sales + Marketing

So users enter data in to "Sales and Marketing Override" to update "Sales and Marketing"...

MarkWarren

Listen to Anand here his best practice is better than mine!

Using the NOT so the most common expression is evaluated first in the IF statement. Nice... 🙂

anand.shekhawat

@MarkWarren

Thank You Mark for being so humble. Really appreciate

Regards,

Anand

Quick Links

Can you help?

Unanswered questions

Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385