I want users to select from existing records and retrieve price value from the same table
Hello Huzefa
- To calculate, use the math column.
- To lookup a column based on data in other columns (which is what you seem to be doing), use a one-line table with a query column and filters in that query column.
Are those pre-calculated prices? Is there a general formula so you can use a math column instead?