I have an interesting question and I hope someone can help me out with this.
I have a field called Location that has the following string values StringValue 1, StringValue 2, StringValue 3.
I would like to create a new field value called StringValue4 based on StringValue1 and StringValue 2 and add it to the original field so that my new field values would be StringValue 1, StringValue 2, StringValue 3 and StringValue 4.
I do not know if this is actually possible, but if it is, I would appreciate help on this.
I have tried this out and it is almost there, but not quite there yet.
IF(Area = 'GA', 'GA',
IF(Area ='F', 'F',
if(Area = 'P', 'P',
if(Location='B' OR Area = 'C' OR Area = 'Comp' OR Area = 'D' OR Area= 'F' OR Area ='GA' OR Area = '','Total'))))
Now the problem is that before the if statements assigns values to Total, the values are already used by GA and F, so the Total value does not give the right Total, but only gives the value for Comp, C, P and B. I want the Total value to be the sum of everything.