Please help about this Error Message


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?


Best Answer

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



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


    Akhil Emmanual