0

Formula Problem ?

 The formula in Cost Field.

'Fully Loaded Cost Rate' * first('b_Bid Hours'.'Spend Hours')

55.22 * 1,100 = 60,742 the formula give me 60,736.60.   5,5 diference. 

4 replies

null
    • John_Halls
    • yesterday
    • Reported - view

    I see there might be a link between the 1,100 and 5.5. Maybe the 55.22 has been rounded up from 55.215?

    Regards John

      • Rafael Sanchis
      • Rafael_Sanchis
      • yesterday
      • Reported - view

       

      Hi John, The round() option isn't working, it's strange.

      The formula is to sample ' Fully Loaded Cost Rate'  = 'Cost Rate' * 1.35

      And 'Cost Rate' is Field Numeric with 2 decimals

    • John_Halls
    • yesterday
    • Reported - view

    Hi  

    If 'Cost Rate' has 2 decimal places and you are multiplying by 1.35, the 'Fully Loaded Cost Rate'  can have up to 4 decimal places. I would use

    'Fully Loaded Cost Rate'  = round('Cost Rate' * 1.35, 2)

    To give consistency to your calculations.

    Regards John

      • Rafael Sanchis
      • Rafael_Sanchis
      • 23 hrs ago
      • Reported - view

       

      round('a_Responsible Person'.'Fully Loaded Cost Rate', 2) * 'Total Bid Hours'

      Ready 

Login to reply

Content aside

  • Status Answered
  • 23 hrs agoLast active
  • 4Replies
  • 18Views
  • 2 Following