Calculated Value doesn't work

  • 18 February 2016
  • 2 replies
  • 1 view

Badge +4

Hi,

I set a formula to use the values I collected from the form to run the auto-calculation, but it seems doesn't work, the result keep showing 0, can anyone help me to understand which step is went wrong?

Thanks!

Zoe

177586_pastedImage_1.png

177587_pastedImage_2.png


2 replies

Badge +7

Hi,

The brackets in the column names are causing issues in the formula which also contains brackets. But it will work if you used the Named Controls rather then Item Properties in the formula and don't use reserved characters in the name.

Jan

Badge +4

thank you so much!happy.png

Reply