Details about this thread
  • State Not Answered
  • Replies 3 replies
  • Subscribers 313 subscribers
  • Views 1127 views
  • Users 0 members are here

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
  • 0 Sugar Employee Badge

    Hi Kaylee Heap,

    Here are a few details that can help readers further consider the stated issue:

    1. In what module is the calculated field?
    2. What is the related module?
    3. What is the formula?
    4. Is the relationship many-to-many, one-to-many, or one-to-one?
    5. Is the relationship a stock relationship or a custom relationship?
    6. What field, and what field type, is the formula in?
Reply
  • 0 Sugar Employee Badge

    Hi Kaylee Heap,

    Here are a few details that can help readers further consider the stated issue:

    1. In what module is the calculated field?
    2. What is the related module?
    3. What is the formula?
    4. Is the relationship many-to-many, one-to-many, or one-to-one?
    5. Is the relationship a stock relationship or a custom relationship?
    6. What field, and what field type, is the formula in?
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