Forums - Thread Details
  • State Verified Answer
  • Replies 6 replies
  • Subscribers 320 subscribers
  • Views 1011 views
  • Users 0 members are here
Forum Actions
Related

Why does this cause my instance of Sugar to crash?

Howard Jennings

The formula saves without any errors. But when I save the field I get an error that crashed my instance. It's on demand, not on my server. This is my little formula. All the fields are correct and the syntax appears to be fine too. It looks worse han it is. It's basically the same calculation with 2 main options occ or vac and 8 options p1, p2, p3 etc. 

ifElse(equal($policy_status_c,"Cancelled"),"0.00",
ifElse(equal($occ_status_c,"Occupied"),

ifElse(equal($bi_program_no_c,"1"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p1_com_occ_t_c")),
divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p1_com_occ_t_c")),12)),
ifElse(equal($premium_freq_c,"Annual"),
currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p1_res_occ_t_c")),
divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p1_res_occ_t_c")),12)
)),
ifElse(equal($bi_program_no_c,"2"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p2_com_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p2_com_occ_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p2_res_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p2_res_occ_t_c")),12),$add_windstorm_cost_c)
)),
ifElse(equal($bi_program_no_c,"3"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p3_com_occ_t_c")),
divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p3_com_occ_t_c")),12)),
ifElse(equal($premium_freq_c,"Annual"),
currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p3_res_occ_t_c")),
divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p3_res_occ_t_c")),12)
)),

ifElse(equal($bi_program_no_c,"4"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p4_com_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p4_com_occ_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p4_res_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p4_res_occ_t_c")),12),$add_windstorm_cost_c)
)),

ifElse(equal($bi_program_no_c,"5"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p5_com_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p5_com_occ_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p5_res_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p5_res_occ_t_c")),12),$add_windstorm_cost_c)
)),

ifElse(equal($bi_program_no_c,"6"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p6_com_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p6_com_occ_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p6_res_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p6_res_occ_t_c")),12),$add_windstorm_cost_c)
)),
ifElse(equal($bi_program_no_c,"7"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p7_com_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p7_com_occ_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p7_res_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p7_res_occ_t_c")),12),$add_windstorm_cost_c)
)),

ifElse(equal($bi_program_no_c,"8"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p8_com_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p8_com_occ_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p8_res_occ_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p8_res_occ_t_c")),12),$add_windstorm_cost_c)
)),

"next bit"),
)))))))
,
ifElse(equal($bi_program_no_c,"1"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p1_com_vac_t_c")),
divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p1_com_vac_t_c")),12)),
ifElse(equal($premium_freq_c,"Annual"),
currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p1_res_vac_t_c")),
divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p1_res_vac_t_c")),12)
)),
ifElse(equal($bi_program_no_c,"2"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p2_com_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p2_com_vac_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p2_res_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p2_res_vac_t_c")),12),$add_windstorm_cost_c)
)),
ifElse(equal($bi_program_no_c,"3"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p3_com_vac_t_c")),
divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p3_com_vac_t_c")),12)),
ifElse(equal($premium_freq_c,"Annual"),
currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p3_res_vac_t_c")),
divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p3_res_vac_t_c")),12)
)),

ifElse(equal($bi_program_no_c,"4"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p4_com_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p4_com_vac_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p4_res_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p4_res_vac_t_c")),12),$add_windstorm_cost_c)
)),

ifElse(equal($bi_program_no_c,"5"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p5_com_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p5_com_vac_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p5_res_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p5_res_vac_t_c")),12),$add_windstorm_cost_c)
)),

ifElse(equal($bi_program_no_c,"6"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p6_com_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p6_com_vac_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p6_res_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p6_res_vac_t_c")),12),$add_windstorm_cost_c)
)),

ifElse(equal($bi_program_no_c,"7"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p7_com_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p7_com_vac_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p7_res_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p7_res_vac_t_c")),12),$add_windstorm_cost_c)
)),

ifElse(equal($bi_program_no_c,"8"),
ifElse(equal($property_type_c,"Commercial"),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p8_com_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p8_com_vac_t_c")),12),$add_windstorm_cost_c)),
ifElse(equal($premium_freq_c,"Annual"),
add(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p8_res_vac_t_c")),$add_windstorm_cost_c),
add(divide(currencyMultiply($sum_insured_c,related($r_rates_bi_buildings_insurance_1,"p8_res_vac_t_c")),12),$add_windstorm_cost_c)
)),

""),

)))))))
)
)

Parents
  • 0

    Hi Howard,

    It looks like you are writing a switch, and a rather complex one, in a feature that was intended to handle trivial data manipulation. I recommend a different approach to your use case.

    For the aspects of this logic where you have "If value a, then b. If value c, then d, etc..." I would make a dropdown list in which the Item Name is the "if" value, and the Display Label is the "then" value, and then replace all of the embedded ifElse logic with a simpler "where Item Name, then Display Label" kind of calculation. Chris Raffle posts a great example of this idea here. 

    I hope this was helpful!

  • 0 in reply to Patrick McQueen

    I've solved this by have individual calculations for each program number starting with an ifElse(equal(Program_number, pX)) if true, it calculate, if false, it returns "" 

    I then have another field that pulls the result.

    This has been running fine for a few weeks without any problems.

Reply Children
No Data