Highlighted
New Contributor

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

3 REPLIES 3
Highlighted
Community Boss

## Re: Getting Invalid error in Logic

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

Highlighted
Regular Contributor

## Re: Getting Invalid error in Logic

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

Highlighted
New Contributor

## Re: Getting Invalid error in Logic

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