Getting Invalid error in Logic

IF 'Headcount Capacity 2' 'Seatings.Less than 50 seats' THEN 'S' ELSE IF 'Headcount Capacity 2' 'Seatings.50-200 seats' THEN 'M' ELSE IF 'Headcount Capacity 2' 'Seatings.201 - 500 seats' THEN 'L' ELSE IF 'Headcount Capacity 2' 'Seatings.More than 501 seats' THEN 'XL' ELSE 'Headcount Capacity 2'

This is refernce to Calculate Office size when user enter data in Headcount so office size need to calculate with this logic either small or medium.

Accepted answers

All comments

Misbah

@suruchi.kapoor

Screenshot of your module would have helped. Anyway here are my suggestions

Suspect 1: IF 'Headcount Capacity 2' 'Seatings.Less than 50 seats' THEN "S" ELSE IF 'Headcount Capacity 2' 'Seatings.50-200 seats' THEN "M" ELSE IF 'Headcount Capacity 2' 'Seatings.201 - 500 seats' THEN "L" ELSE IF 'Headcount Capacity 2' 'Seatings.More than 501 seats' THEN "XL" ELSE 'Headcount Capacity 2

Put highlighted in double quotes

Suspect 2: 'Headcount Capacity 2' 'Seatings - I believe it is the name of the list, are these single quotes within a list item name? If yes then ok, otherwise these are not required in between.

Suspect 3: ELSE 'Headcount Capacity 2' - What is this? What should the system do when it doesn't get results in S,M,L or XL. I doubt this part.

Thanks,

Misbah

Akhtar.shahbaz

@suruchi.kapoor

Already @Misbah pointed out the error for your formula.

It seems you are using " Text" formatted line item in your formula with multiple IFs statement. As the best practice says to avoid "Text" formatted line item as much as possible because it consuming more space.

I have seen best workaround by @DavidSmith to avoid multiple IFs statement https://community.anaplan.com/t5/Anaplan-Platform/Another-work-around-method/m-p/42250#M4513

I tried to replicate your case with the help of David's example.

1. Create a seat type list with top level item

2. Create a system module:

3. Create flat list for all the possible range.

System module

4. I am assuming you already have a place holder for head count in your input module.

5. Create one cal module to know the seat type for different possible combination

Make sure summary for Seat type line item should be " Last not blank"

6. Now your final module should be like this:

Hope this helps!

Thanks

Akhtar

suruchi.kapoor

Thank Akhtar ...It helped. i have tried in same manner and it worked

Quick Links

Can you help?

Unanswered questions

OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled
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