100 - $discount_pct
would tke 17.5 and produce 82.5
GetValue ( $discount_pct ; $counter ) * $toplinenumber
It messes with the counter that way. Only does it once and there are 4 portal fields im filling in on this specific application.
If i remove the 100- $discount_pct it fills the others in.
Also how do i get it to round up?
Number functionsNumberare used to manipulate numeric data.Click a function name for details.
This functionReturnsAbsThe absolute value (a positive number) of a number.CeilingA number rounded up to the next integer.CombinationThe number of ways to uniquely choose a specified number of items from a set of specified size.DivAn integer of the specified number divided by the divisor.ExpThe value of the constant e (the base of the natural logarithm, equal to 2.7182818) raised to the power of a specified number.FactorialThe factorial of a specified number stopping at 1, or at a specified number factorial.FloorA number rounded down to the next lower integer.IntThe whole number (integer) part of the value you specify, without rounding.LgThe base 2 logarithm of the specified number, which can be any positive value.LnThe base-e (natural) logarithm of the specified number.LogThe common logarithm (base 10) of the specified number, which can be any positive value.ModThe remainder after a specified number is divided by divisor.RandomA random number between zero and one.RoundA number rounded off to the specified precision (number of decimal places).SetPrecisionAny math functions contained within the specified expression to the specified digits of precision, if the math function supports extended precision.SignOne of three possible values: -1 when the specified number is negative, 0 when it's zero, and 1 when it's positive.SqrtThe square root of a number.TruncateA number truncated to the specified precision (number of decimal places), without evaluating the value of the discarded digits.Symbol+PlusAdds two values-MinusSubtracts the second value from the first*MultiplyMultiplies each value/DivideDivides the first value by the second^Power OfRaises the first value to the power of the second value( )PrecedenceFileMaker Pro evaluates formulas from left to right, performing multiplication and division before addition and subtraction. Using parentheses lets you change the order: FileMaker Pro evaluatesbetween parentheses first.
try it this way:
( 100 - GetValue ( $discount_pct ; $counter ) ) * $toplinenumber
Though to really use it as percentage, it should be:
( 100 - GetValue ( $discount_pct ; $counter ) ) * $toplinenumber / 100