Forum Discussion
Expression:Error: Calculated Column trying to convert to fraction instead of decimal
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
Community ChampionHi 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.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Thanks Mariusz , I have just changed the three columns to Decimal Number and still the same error. Ive added screen grabs of the data below, as you can
Symbion is Wholesaler3 & Sigma is Wholesaler4 in my code above
- Mariusz
Hi 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.
LinkedInHi 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!