Forum Discussion
lachie-1992
6 years agoRegular Visitor
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 ...
- 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
Mariusz
Community Champion
6 years agoHi lachie-1992
Any chance you can share a sample file?
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
lachie-1992
6 years agoRegular Visitor
Hi Mariusz I was being stupid and didnt realise i had changed one of the data types by mistake. Your first answer was correct 🙂
Thankyou very much!