I am trying to build a formula in a table that pulls the current cost for a product based on an effective date, this is so that I can see the most current cost based on the a table that has multiple cost adjustments to products.
Question
Effective Date Formulas
+24If you have a table of products in a relationship where one product has many costs adjustments, then you can simply go to that relationship and make a summary field of the maximum Effective date of the cost adjustments
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.