I have a strange issue that’s really confusing me. I have two drop down fields that have values in increments of 0.5 (0, 0.5. 1.0, 1.5, 2.0).
When I add these in a calculation field (let’s call it ‘Calc1’ which has id 3), I don’t have any issues. If I select 0.5 + 2.0 I will get 2.5.
However, when I copy the result of Calc 1 into a new field Calc 2 (using the merge tag {:3}) then it cuts off everything after the whole number. so instead of getting the result 2.5 it only shows 2. There is no rounding on any field.
In case you are wondering why I need a second calcualtion field, it’s because I will use that as a condition to only display the result if it is greater than 3. However, this problem still exists when there is no conditional on the field.
Thank you for any help.