Calculated field, disable decimals (1 Viewer)

[dongilles]

Hello all,

I have a problem and I cant seem to fix it, and because I do know how to describe it, I cant find it on the forum or on google. Hopefully you can help me.

I can explain it best with an example

In a form I have:
- 3 fields with values. These values are 33.3% of the original value, so these are already calculated.
- a 4th field counts these numbers together.

With the push of a button these number are copied an other form.

Now the problem:

because I copy calculated values there are a lot of decimals and eventough the first form does not show decimals because I disabled them in the propperty settings, when I copy the values the decimals are in the copied field.

Hopefully someone here can understand my problem

 

[Minty]

This doens't make a lot of sense I'm afraid. If the values are always 33.3% (A third) and the 4th field is always the sum of them it's only ever going to be the original value.
You don't need 4 fields at all, as all these values can always be calculated from the original.

You can fix the number of decimals as a display format or you can force them to a fixed value using the round() function or Int dependong on the result you want - see here http://allenbrowne.com/round.html