Details about this thread
  • State Not Answered
  • Replies 3 replies
  • Subscribers 307 subscribers
  • Views 866 views
  • Users 0 members are here
Related content from around SugarClub

I have calculated fields based off related modules. My understanding is that those calculated fields automatically re-calculate but I'm finding that only certain calculations are recalculating. When I select all, I do have the option to recalculate val

Kaylee Heap

I have calculated fields based off related modules. My understanding is that those calculated fields automatically re-calculate but I'm finding that only certain calculations are recalculating. When I select all, I do have the option to recalculate values but we have tons of calculations and even that mass re-calculate function would be time consuming. Any ideas on why all the fields are not automatically re-calculating?

Parents Reply Children
  • 0 in reply to Patrick McQueen

    1. The calculated field is in a custom module I made, Fuel Price.

    2. The related module is also a custom module I made, Estimated Fuel Cost.

    3. The formula is:

    multiply(related($fpc_fuel_price_efc1_est_freight_cost,"fuel_surcharge_c"),
    add(
    multiply(
    divide(
    multiply(related($fpc_fuel_price_efc1_est_freight_cost,"west_hourly_c"),
    divide(
    multiply($miles_c,2),related($fpc_fuel_price_efc1_est_freight_cost,"miles_per_hour_c"))),950),100),

    ifElse(equal(related($sfrv1_storage_facility_efc1_est_freight_cost_1,"name"),""),
    multiply(
    divide(multiply(related($fpc_fuel_price_efc1_est_freight_cost,"west_hourly_c"),.5),950),100),
    multiply(
    divide(
    multiply(related($sfrv1_storage_facility_efc1_est_freight_cost_1,"est_load_time_c"),related($fpc_fuel_price_efc1_est_freight_cost,"west_hourly_c")),950),100)),

    ifElse(equal(related($l1_locations_efc1_est_freight_cost_1,"name"),""),
    multiply(
    divide(multiply(related($fpc_fuel_price_efc1_est_freight_cost,"west_hourly_c"),.5),950),100),
    multiply(
    divide(
    multiply(related($l1_locations_efc1_est_freight_cost_1,"average_dump_time_c"),related($fpc_fuel_price_efc1_est_freight_cost,"west_hourly_c")),950),100)

    ))
    )

    4. Fuel Price is one-to-many Estimated Freight Cost

    5. Custom Relationship

    6. Decimal field type