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

Cara mengubah nama penumpang Batik Air
Untuk mengubah nama penumpang Batik Air Anda bisa hubungi Customer Service WhatsApp 0897-5555-324
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…