I am looking to create an app that will compare bills to the service contracts. I have a table for the Contracts and one for the bills with a relationship that shows that the contracts can have multiple bills. I need to create some sort of Automation or report that will compare the bills to the contracts and only return the bills that are greater than the contracts. What would be the best way to do this?
Question
Bill to Contract comparisons
This topic has been closed for replies.
+10There are many ways to do this, but here is one using simple native features.
On the relationship "Contracts have many Bills", create a lookup field [Contract Price] so we can carry that value down from the parent table to the child table
On the Bills table, create a new formula field [Price Variance] that calculates [Contract Price] - [Bill Price]
On the Bills table, create a new report and use the [Price Variance] as a filter (is greater than 0) and this should provide you with all Bills that are greater than the contract price. Setup report subscriptions with the new report for automating the reports via email.
On the relationship "Contracts have many Bills", create a lookup field [Contract Price] so we can carry that value down from the parent table to the child table
On the Bills table, create a new formula field [Price Variance] that calculates [Contract Price] - [Bill Price]
On the Bills table, create a new report and use the [Price Variance] as a filter (is greater than 0) and this should provide you with all Bills that are greater than the contract price. Setup report subscriptions with the new report for automating the reports via email.
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.