Hi,
I have a table that itemises quotes, using AI Builder. I have the following columns
- Quote Reference (lookup to quote table summary, also coming from AI Builder)
- Item Name (AI Builder)
- Qty (AI Builder)
- Price (AI Builder)
- Total Price (Calculated Field).
There will be many instances of repeat materials, but prices will change over time.
So I want to return the min quoted price for an item, last quoted price ; and then do some variance calculations on them.
Thanks


Report
All responses (
Answers (