Forum Discussion

JamesSwett's avatar
JamesSwett
Qrew Member
7 years ago

Bill to Contract comparisons

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?
Formulas and functions
Quickbase Automations
reports and charts
  • EverettPatterso's avatar
    EverettPatterso
    Qrew Captain
    7 years ago
    There 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.