Forum Discussion
Cannont Convert Value Error
Like many others im getting the error that is inicating its returning test and not a value. However both columns (trade price, and % difference) are values and not text so im struggling how to get rid of this.
8 Replies
- MohammadLoran25
Solution Sage
Hi
Please provide more info including a test data.
Here is one of the data sets. The other im pulling from a data cube through a direct query so i cannot screen shot that informatoin.
- MohammadLoran25
What do you want to achieve by creating this calculated column?
I cannot understand the logic of the way u have used the CALCULATE Function.
My intent was to sum the amounts of the trade agreements for each item for each company an multiply it by the % difference using the same filters of item and company.
