Calculations in conditional logic shows formula instead of result

  • Resolved skilderth

    (@skilderth)


    3 months ago

    I am using conditional logic for calculations in my form. However, for some of my Totals the result is showing the formula (eg. 50+50++) instead of the result (100)

    In the order of my conditions, the calculations are as follows:

    1. Calculating ‘Amount 1-4’ by [Kilometer 1]*0,21
    2. Calculating hidden field ‘Total KM costs’ by [Amount 1]+[Amount 2]+[Amount 3]+[Amount 4]
    3. Calculating hidden field ‘total other costs’ by [Amount in Euro 1]+[Amount in Euro 2]+[Amount in Euro 3]+[Amount in Euro 4]
    4. Calculating hidden field ‘total all’ by [Total km costs]+[Total other costs]

    Calculation 1 and 2 work, however 3 shows the formula instead of the result. Therefore 4 shows the calculated total of KM costs, plus the formula of 3.

    What am I doing wrong?

    Some images as background info:

    • This topic was modified 3 months ago by skilderth.
    • This topic was modified 3 months ago by skilderth.

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter skilderth

    (@skilderth)

    I managed to make it work by not using calculated fields in the total field. Instead, I made an all-combining formula for the total field.

    I used this:

    • ( ( km1 + km2 ) * 0,21 ) + Other amount 1 + Other amount 2

    Instead of this:

    • Total travel costs + total other costs

    It would be an amazing feature to be able to calculate with calculated fields. Is this a possibility?

    • This reply was modified 3 months ago by skilderth.
    Thread Starter skilderth

    (@skilderth)

    Still not working. If one of the variables is empty, it shows the formula instead of the result. What can I do to fix this?

    Plugin Support Md Raihan

    (@mdraihanu)

    Hello @skilderth ,

    Thank you for using Bit Form.

    Could you please send us the link to your form page, as well as the exported form file, to our support email: [email protected]? This will allow us to investigate the problem and provide you with an accurate solution.

    Plugin Support Md Raihan

    (@mdraihanu)

    Hello @skilderth ,

    If we do not receive further collaboration from you, we will not be able to resolve your issue. If you do not contact us within the next two days, we will consider this topic resolved. However, if you believe the problem persists, you are welcome to reopen the discussion.

    Thank you.

    Plugin Support Md Raihan

    (@mdraihanu)

    Hello @skilderth ,

    Sorry, please ignore my previous message. We have received your email and will provide a solution/suggestion as soon as possible. Thank you

    Plugin Support Md Raihan

    (@mdraihanu)

    Hello @skilderth ,

    To fix the issue where the formula is showing instead of the result in your conditional logic calculations, make sure that all input values are treated as numbers. If a number field is left blank, it should automatically return 0 instead of causing errors.

    When you convert the input value to a number, a blank field will default to 0, preventing any calculation errors. If you don’t convert it, the field might return null, which could result in the formula being displayed instead of the correct calculation (like this: 12+23+234+)*0.21)+234234+234++234).

    Check out the image for guide on how to convert your input to a number. Image link: https://prnt.sc/rn17nYydAk4f

    • This reply was modified 2 months, 3 weeks ago by Md Raihan.
    • This reply was modified 2 months, 3 weeks ago by Md Raihan.
Viewing 6 replies - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.