• Resolved adsy1978

    (@adsy1978)


    I am trying to create a rather complicated formula and for some reason I am hitting an issue.

    I currently have as a single formula:
    ((range_field_id_0*2.08)*48)+((range_field_id_1*4.7)*48)+((range_field_id_2*4.7)*48)+((range_field_id_3*70)*48)+((range_field_id_4*25)*48)+((range_field_id_5*5.83)*48)+((range_field_id_6*5.83)*48)+((range_field_id_9*12.5)*45)+((range_field_id_10*12.5)*45)+((range_field_id_11*12.5)*45)+((range_field_id_12*12.5)*45)+((range_field_id_13*37.5)*45)

    For some reason the ((range_field_id_1*4.7)*48) section is triggering a large value to be calculated when it shouldn’t be.

    I have tried splitting my formula fields to check the values into different total calculations, and when I do it works fine.
    ((range_field_id_0*2.08)*48)+((range_field_id_1*4.7)*48)+((range_field_id_2*4.7)*48)+((range_field_id_3*70)*48)+((range_field_id_4*25)*48)+((range_field_id_5*5.83)*48)+((range_field_id_6*5.83)*48)

    and

    ((range_field_id_9*12.5)*45)+((range_field_id_10*12.5)*45)+((range_field_id_11*12.5)*45)+((range_field_id_12*12.5)*45)+((range_field_id_13*37.5)*45)

    But if I link them together in any way, issues result. I have also tried with triple parentheses ((( at the start of the formula and nesting them all to be calculated by *48, but I get the same issue.

    I would appreciate some feedback on how I can get past this issue.

  • The topic ‘Issue with nested formulas’ is closed to new replies.