I want to create a list where i can manually put a number in a list for the [Rent term] by the function InputSum. After putting in a number in the column where the InputSum function is, qv should compare the number with the existing number in the database and assign the proper factor.
in a table chart i have
Category=Car, Ship & Real Estate, now i create a function called InputSum([Rent term]), now i add the numbers in the function.
Category InputSum([Rent term]) [Rent term] Factor
Car 24 12 or 24 6% or 5%
Ship 12 12 or 24 8% or 4 %
Real Estate 36 36 or 48 2% or 1%
Then QV should compare the adding number with the existing numbers in the database
Car = 24 search for 24 in [Rent term], if you find it , return the factor 5%
Ship= 12 search for 12 in [Rent term], if you find it , return the factor 4%
Real Estate= 36 search for 36 in [Rent term], if you find it, return the factor 2%