Issue with nested formulas
-
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.