How Alternate Values Are Filtered in Formulas
Within Ediphi, when working with quantity formulas in your project, it’s important to understand how Alternates are handled in specific instances. The following formula values are designed to exclude other unaccepted Alternates:
Within Detailed Summary and Line Item Views
When working within an unaccepted Alternate’s line items, formulas used pull values only from the items assigned to that specific Alternate. This ensures accurate and isolated calculations when analyzing each Alternate individually. Keep in mind that any Sort Codes or Category values will show all estimate line items plus any accepted Alternate items, whereas viewing a specific unaccepted Alternate lines will show only the items explicitly assigned to it.
Sort Codes
- Quantity
- Total Cost
- All LMSEO Values (Labor total , Materials total, etc.)
Category
Within Estimate Markups
When working within an Alternate, formulas used in Markups pull values only from the items assigned to that specific Alternate. This ensures accurate and isolated calculations when analyzing each Alternate individually. Keep in mind that the Base Bid view shows all estimate line items plus any accepted Alternate items, whereas viewing a specific Alternate will show only the items explicitly assigned to it.
Estimate Values
- Cost of Trades
- Grand Total
All LMSEO Values (Labor total, Materials total, etc.)
Sort Codes
- Quantity
- Total Cost
- All LMSEO Values (Labor total, Materials total, etc.)
If you have any questions, feel free to contact our support team, and we’ll be happy to help!