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

any suggestion on how to resole above error

Accepted answers

All comments

Looks like the line item you are referencing in a SUM, SELECT or LOOKUP formula is Text or Number formatted. Change the line item that is being referred to so that it is LIST or DATE formatted. If it is currently TEXT then a FINDITEM might be helpful.

SPLASHIMAGE

Thanks, it worked

nikhilkumar1602

Thanks, it worked 👍

Quick Links

Can you help?

Unanswered questions

Management Report allows for dynamic filtering, but columns don't dynamically change
It's now possible to use the additional insights to have dynamic filters, however the columns in the table are fixed widths. It's quite unfortunate that the ability is added, but the layout isn't dynamic. I understand that a report is more fixed, but adding dynamic columns would really help make the management report…
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…