El_Pablo Posted November 8, 2008 Posted November 8, 2008 Hi, In a lookup when there's no exact match, how can I get the average between the lower and the higher value? Thanx
comment Posted November 8, 2008 Posted November 8, 2008 Try a calculation field along the lines of: ( LookupNext ( Related::Value ; lower ) + LookupNext ( Related::Value ; higher ) ) / 2
El_Pablo Posted November 8, 2008 Author Posted November 8, 2008 Never noticed this function before. Did the job! Thanx
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now