I have a calculated field like this:
Case( Division = "Theatrical", Bill_Total).
Now the client has added a new division: A/V
Now the calculation does not work:
Case( Division = "A/V", Bill_Total)
I could do a substitute to get rid of the "/", but curious if there are other way to do this.