Please help about this Error Message

Hi
As part of my training activities :
I am getting this error message while applying the sum formula.
"Data type mismatch: format other than LIST or DATE being referenced as a relation"

I am applying this formula
'REV03 Margin Calculation'.Revenue[SUM: 'SYS06 Product Details'.Size]

Can you please help me to resolve this issue?

Accepted answers

anand.shekhawat

Hi @cavinayyadav

Yeah that seems to be a data type mismatch.

According to the formula that you have written, make sure that the 'Revenue' that you are pulling from REV03 module is number formatted & 'Size' line item in SYS06 Product Details module is 'List' formatted. Then only the formula would work.

What my intuition says that you might have loaded the size details in SYS06 module in text format maybe, that is why the formula is not working.

Please let me know if it helps.

~Anand

All comments

AkhilEmmanual

Hi @cavinayyadav

Can you check the format of size line item from SYS06 used for mapping .Make that format as size list . This may solve your issue.

Regards

Akhil Emmanual

anand.shekhawat

Hi @cavinayyadav

Yeah that seems to be a data type mismatch.

What my intuition says that you might have loaded the size details in SYS06 module in text format maybe, that is why the formula is not working.

Please let me know if it helps.

~Anand

Quick Links

Can you help?

Unanswered questions

Missing Column Headers in Anaplan Export When Using API
Hi Community, I’m encountering an issue where an export created in Anaplan is missing column headers when retrieved via the API. However, when I manually run the same export from the Actions tab, the downloaded file includes the headers. Has anyone experienced this behavior before? I’d appreciate any insights into the root…
Importing from Data Hub: Incorrect or Missing Mappings in Target Model
When importing data from a Data Hub to another model, I'm seeing values in the target model that don't exist in the source. For example, seller assignments are being tagged with subregions that aren't present in the source data - some assignments are missing expected tags, while others are mapped to seemingly random…
ANAPLAN XL View
Hi, I need help in pulling a specific view in Anaplan XL. The first grid should display attributes of various projects, while the second grid should present the monthly financial data for these projects. Thanks in advance.