Please help about this Error Message

cavinayyadav
cavinayyadav
in Academy Discussions

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?

Screenshot 2023-07-05 121024.png

Tagged:

Best Answer

  • anand.shekhawat
    anand.shekhawat
    Answer ✓

    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

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers

  • AkhilEmmanual
    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

Categories