#DATATYPE ERROR

[Former Member]

Hi Guru's,

Iu2019ve got an issue here on some of my reports on QA, the very same reports are running fine on Dev environment but the problem is in QA some columns are showing #DATATYPE on the reports when run on InfoView in QA, what is strange is the fact that the same report if I run it from BO rich client it runs fine and it shows the figures without any problems.

Iu2019ve checked these measures at Universe level and everything looks ok, like the function is set as sum.

Any advise from you side please?

[former_member793810]

This means it is throwing wrong data. Suppose your data is numerical but it is throwing char or something else then this error comes.

What happens, The value_if_true and value_if_false parameters can mix string and number or string and date/time data types. If these data types are mixed, the function returns a string.

Date/time and number data types cannot be mixed; this results in a #DATATYPE error.

Can you check your variable again please?

Or you can refresh the report again to see if this error is gone.

Regards,

Bashir Awan