nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Data type mismatch: format other than LIST or DATE being referenced as a relation

Mahesh839

When I am trying to enter the formula in REP02 Size Margin Report revenue i am getting an error like this ...

(Data type mismatch: format other than LIST or DATE being referenced as a relation)

mj_138214.png

bgh_138214.png

Comments

mburdak

Hi @Mahesh839

This is happening because the format of your 'Size' lineitem in SYS06 Product Details is not set as the Size List.

Please check the format and change it accordingly, you will need to import the size data again after changing the format.

Regards,

Mandeep

ryan_kohn

@mburdak @Mahesh839 FYI I moved this post to the Academy & Training forum.

Quick Links

Recent release news

September 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our September 2026 official release notes. There you'll find information on: User Experience KPI cards Mobile Zoom and pan KPI Conditional formatting Intelligence CoModeler Analyst Optimizer Disclosure Management Refreshed user interface Anaplan Data…
FCR Release 2608.3 Advisory: Notice of recent changes
Please take note of the following changes in our latest 2608 release: Multi-dimensional calculations now require valid rules. As of 2608, the multi-dimensional calculation process no longer runs when invalid rules are present - for example, a rule referencing an invalid member (one that no longer exists in the dimension).…