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

Pilla

Not sure what the issue is! Please help.

Screen_Shot_2021-03-21_at_11_102430.png

Comments

JaredDolich

@Pilla

This message means that the format of your line item does not match the result of your formula or you are trying to lookup/sum a value that doesn't match your line item format.

If you want, I'll take a look at your formula. Just let me know also what is the format of the line item.

Pilla

I'm trying to solve level 1 certification question 6 and I'm stuck. This is the formula I'm using for medical costs

'EMP02'.Medical Costs[SUM:'SYS08 Module'.Region, SUM:'SYS08 Module'.Role]

JaredDolich

@Pilla

A couple of callouts:

The formula syntax is correct.
There should be spaces after the SUM: (after the colon)
Make sure your line item format is "NUMBER"
Make sure your time scale for the line item is "YEAR"

See if that helps. If not, then send me a screenshot of your REP04

Misbah

@Pilla

What it means is that either your Role or Regions is not list formatted. One or both of them are being referenced as text. Can you please verify if both Region Line item and Roles Line item in SYS08 module are list formatted

Misbah

Zhiying

Hi,

I tried to format role to list under SYS08 and it says format of mapping used doesn’t match any dimension of the source. What does that mean?

Abhinav369

I'm facing same issue and i corrected everything you told but still getting popup for data mismatch: format other than list and date is being refrenced by as a relation

Quick Links

Recent release news

April 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our April 2026 official release notes. There you'll find information on: Polaris Trigonometry functions MOVINGSUM on general lists Line item limit Security and tenant administration CAPTCHA on basic authentication Anaplan XL (version 2604) Offline writeback…
Recording now available! April 29 platform release event
If you missed our April 29, 2026 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…