Thread Details
  • State Not Answered
  • Replies 4 replies
  • Subscribers 354 subscribers
  • Views 834 views
  • Users 0 members are here
Forum Actions
Related

Service Duration field name for formula?

Ada Napierala

Hello, 

I have a custom formula in SugarCRM that calculates New Annual Recurring Revenue:

ifElse( 

equal($arr_yes_no_c,"Yes") 

,ifElse( 

equal($product_type,"Renewal") 

,0 

,ifElse( 

equal($product_type,"Renewal_with_upsell") 

,subtract($discount_price,$renewal_arr_c) 

,ifElse( 

greaterThan(subtract($discount_price,$renewal_arr_c),0) 

,subtract($discount_price,$renewal_arr_c) 

,0 

) 

) 

) 

,0 

) 

I would like to modify, to add another condition. However, this condition includes Service Duration Unit - I cannot find a field name for it, do you know where can I find the Field Name (not Display Label) for it? 

Parents
  • 0

    Hi  ,

    The field name for Service Duration Unit is service_duration_unit. However, when trying to build a formula in the Revenue Line Items (RLI) module with that field, the formula will not save since it does not recognize the field name. 

    The 'subtotal' field in the RLI module has a stock formula using both service_duration_value and service_duration_unit in its calculation. However, if you go into that formula in Studio and attempt to save it without making any changes, you cannot proceed their either since neither field validates. 

    I consider this to be a bug; I recommend raising the issue with Sugar Support and highlighting how stock fields in Sugar are able to use these fields in calculations (though they cannot be updated to still use those fields). 

    Chris

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

Reply
  • 0

    Hi  ,

    The field name for Service Duration Unit is service_duration_unit. However, when trying to build a formula in the Revenue Line Items (RLI) module with that field, the formula will not save since it does not recognize the field name. 

    The 'subtotal' field in the RLI module has a stock formula using both service_duration_value and service_duration_unit in its calculation. However, if you go into that formula in Studio and attempt to save it without making any changes, you cannot proceed their either since neither field validates. 

    I consider this to be a bug; I recommend raising the issue with Sugar Support and highlighting how stock fields in Sugar are able to use these fields in calculations (though they cannot be updated to still use those fields). 

    Chris

    Co-Founder | SugarCRM's 2024 Global Outfitters Partner of the Year

Children