Hi,
Why would a calculation work on one part of a form but a similar calculation won’t work on the same form?
I created a simple calculation field: AAA + ” ” + BBB – This returns “John Doe”.
I created a similar calculation field: CCC + ” ” + DDD – This returns ” ” (Nothing, it should return “Jane Smith”)
All fields (AAA,BBB,CCC,DDD) are populated with entries.
I tried removing the layout entry and re-applying it but no success.
I tried removing the field and re-applying it with a new calculation, no success.
I tried re-entering CCC & DDD fields, with refreshes, no success.
Perplexed…
This for me is quite often that I forgot to swap the type from the default of “Number” over to “Text” on the newly created calculation field.
Yup. That’d do it. The Result Type is important to match what you’re actually returning from the formula.
Thanks guys, Spot on again. Apologies for the newbie oversight. :-)
No worries, been there, done that, maybe even emailed Brendan about it, doh! :D
.
