Dynamic Content Expression Not Working

Question

Hi folks, I am trying to insert some Dynamic Content into a Text box. The Dynamic Content should sum the values of one field and divide by the sum of another in order to create a percentage. However, it won't calculate the value and just returns the name "LMI Percentage." I'm new to Experience Builder so sorry if this is an easy answer. When I used the Statistics option and just insert SUM({LMI_UNIT}) that works but the Expression is giving me a headache. Thanks

DanJiang · Answer

If that is the case, I am afraid we could not fix this, as the expression is the calculation result of each part and one part fails will cause the whole expression value missing.

JustinH · Answer

Thanks for your help- I did find the issue. One of the fields is not calculating correctly even though it has an integer field type. Do you happen to have any guidance for this? Not sure what I can do to fix this

JustinH · Answer

Hmm... It seems that I have set each feature upon adding it to the default view and still have the same issue. Is there a limit to the expression? I am trying to add the sum of 7 fields like my screenshot above...