I've got several fields that use drop down lists. My intent was to get the item chosen from the drop down list in the field.Value and use the numerical part of that to populate another field, e.g.
Veteran (Vet) AdCost +7
What I was hoping was that the calculation of this field would pull the 7 out, thisfield.Value + thatfield.Value would sum as 7 plus...
Maybe I'm going about this the wrong way but I'm getting a field sum of 0. I tried a few variations and the conclusion I've come to is that numerical values on their own such as "+5" do work but if I've got some text in there as well the sum is 0.
"Veteran (Vet) AdCost +7" - doesn't work the sum is 0
"+2 (stuff)" - doesn't work the sum is 0
"+5" works great, the sum is 5
"Animist Anm AdCost +3" - doesn't work the sum is 0
"AdCost +7 Veteran Vet" - doesn't work the sum is 0
I just wanted to check and see if this is the expected behaviour or if anyone has an alternative.