What are the formulas for Team_A, Team_B and Team_C? If these are measure, it's going to treat the field above as a measure, even though it returns a string.
There is no formula applied there, that should be the final result if the condition is satisfied.
if [Team_A] > 0 and [Team_B] = 0 and [Team_C] =0 then "A Only"
Team_A = Sales from Team A
Team_B = Sales from Team B
Team_C = Sales from Team C
The purpose of newly created column is to tell me from where the sale is coming from.
In that case, nothing jumps out at me....possible to share the workbook?
This what I am trying to achieve. First 3 columns are number however the newly created column is String.
Team A Team B Team C Team and Calls 12 0 0 A Only 0 10 0 B Only 0 0 4 C Only 22 5 0 A and B 0 8 2 B and C 7 0 12 A and C 12 5 9 A/B/C 0 0 0 No Sales
Well good news and bad news...using the data set above, I copied and pasted your formula exactly and it worked. Not sure why it's breaking on your end.