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)

bgh_138214.png

mj_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

Register for our July 29 platform release webinar!
Anaplan's next quarterly platform release webinar will be held July 29, 2026 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of new…
June 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our June 2026 official release notes. There you'll find information on: User Experience On-the-fly chart creation CoModeler Optimizer Integration with Workflow Extended runtime Forecaster Workflow Workflow builder undo and redo Batch submission and approvals…