I have a form that has calculated fields. While the field is correct in the "Edit View" of the form, in the "Display View" of the form, the field is not displaying the calculation. The "recalculate formula on view mode" is set to "yes."
Does anyone know how I should fix or troubleshoot this?
Solved! Go to Solution.
In that case, you should probably post screenshots of your form controls with their settings, and also the formula itself. Give as much info as you can so others can help recreate the issue on their environments.
Thank you for the additional information. Unfortunately, I'm not going to have time to look any further into this until maybe later this week, and I'm not seeing anything obvious that would be causing the issue. Hopefully someone else in the community can use your info to figure it out.
can you add calculate value controls on the form with following formulas
and post how do they evaluate in edit and view mode.
make sure they all recalculate in view mode
I think it's having an issue with replacing the $ because replace uses regular expressions and $ is a special character. You may need to replace the commas also so try a regular expression that replaces everything but the numbers and the decimal point like this.