L1MB Activity 8.8.4 - Unable to Add Formula

Hi there,

I am trying to use the following formula, as stated in the training curriculum, but continue to get an error for "Data type mismatch" (attached). I've read through the related issues but none seem to be the same error. Wondering if I imported the size incorrectly? The numbers lined up correctly but did not have the gram measurement as shown in the example.

Formulas that prompt the error:

'REV03 Margin Calculation'.Revenue[SUM: 'SYS06 Product Details'.Size]

'REV03 Margin Calculation'.Cost of Sales[SUM: 'SYS06 Product Details'.Size]

Appreciate any help, please!

Thanks!

Error_147817.png

8_147817.png

Comments

JaredDolich

@stephaniejlw

Most likely the "size" line item needs to be formatted as a list (size). I suspect you have it formatted as text. See if that helps!

stephaniejlw

Hi @JaredDolich,
Thanks for the quick response. I have it formatted as a number, and if I change it to list, it removes the data from the import in that line. Hopefully I've not misunderstood your suggestion? Any other advice is greatly appreciated. Thanks!

JaredDolich

@stephaniejlw

Hang in there. You're on the right track. In Anaplan, we have a new formatting type called the LIST format. so in this case you will be formatting "Size" as a LIST. In this case the "Size" list. The only way to use SUM and LOOKUP is to use a list formatted line item. Here's how SYS06 should look. Give it another try! You'll need to reload the size properties after you change the format.

stephaniejlw

Thank you so much, @JaredDolich! That fixed my issues 🙂

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…