Hi
I have a GM calculation as below
([AFG Invcd Gross Amt - Division_Sales AFG]+[AFG Allowance Amt - Division_Sales AFG])+([AFG Prepaid Freight - Division_Sales AFG]*-1)+([AFG Issued Cost Amt - Division_Sales AFG]*-1)+([AFG Total Net Freight - Division_Sales AFG]*-1)+([AFG Ohio Cat Tax - Division_Sales AFG]*-1)+([AFG Pick Up Amt - Division_Sales AFG]*-1)
When I had - (substraction) I was getting an invalid datatype varchar error. I was able to get it validated and running with the calculation where I + and multiple by -1.
However, on my per pound calculation when I add / [AFG Calc Net Weight - CompanyUM_Sales AFG] I again get the invalid data type error. Has anyone struggled with this before? Obviously the values are numeric as i was able to multiply * -1 and do the +. It just seems like i have issues when - or / multiple measures.
Thoughts?