Forum Discussion

lachie-1992's avatar
lachie-1992
Regular Visitor
6 years ago
Solved

Expression:Error: Calculated Column trying to convert to fraction instead of decimal

So i am trying to create a new calculated colum to calculate the true sales price of our products using a calculation, it seems simple enough except i am getting an Expression:Error and i cannot for ...
  • Mariusz's avatar
    6 years ago

    Hi lachie-1992 

     

    The error is stating that "We cannot apply operator / to types Text and Numbers" so the first thing you can do is check and apply correct data types on your columns that you use for this calculation.

     

    If this does not help, please provide a small data sample + screen prints, including both good records and bad records of base columns and Custom column with the error.

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn