Database Help am I missing

Discussion in 'OT Technology' started by Moistfly, Nov 21, 2005.

  1. Moistfly

    Moistfly Anal Bum Cover

    Oct 19, 2001
    Likes Received:
    Ok, I have a field named "vanity total" which uses the following calculation:

    Round(Total sq ft material * Price +
    Apron Cutouts * 4.5 +
    Seams*20 +
    If(substrate="Yes";Total sq ft material*1;0)+
    (Bowl Cutouts-1) * 25+
    25*Undermount Bowl;2)

    where Total sq ft material and Price are seperate fields entered by the user

    really ... REALLY simple stuff and it always works except I currently have a value of 3.33 in the "total sq ft material" field and 8.95 in "Price" ... and it's ouputting 4.80 in my "vanity total" field. All other fields used in the calculation (seams, rods, substrate etc...) are blank ...

    Is there something obvious I'm missing in that calculation that's giving me the incorrect total for only these 2 input values? I feel like a fucking douche not being able to figure this out but :wtf:

Share This Page