Groupings is not accurate

[Imee_Lee]

On this view,

I need to create groupings based on the Max Price and Listing Price.

The amount should match, but when I tried to do the grouping it did not show the correct numbers.

here's the current setup.

Here's the outcome.

The Max Price Should be $280k but why is it that the Listing Price of $285k was included on this group which supposedly was not?

[Arthur_Tutt]

@Imee_Lee  For sure I got you 😉

So on the Client Table I added new field called 'status'. 

Then on Client Hit List View I add filter to filter by status:

 

Make sense?

[Arthur_Tutt]

@Imee_Lee  WAIT! I think I just figured out the problem. In the script I was quarrying the entire Client Table, instead of just The Hit List View. You'll need to update lines 5-7 of the script w these lines (adjusting Table / Field  / View names to match yours as usual)

// get client table
var clientTable = base.getTable("Client Briefs");
var clientHitList = clientTable.getView("Client Hit List");
var clientQuery = await clientHitList.selectRecordsAsync({fields: ["Client", "Min Purchase", "Max Purchase"]})

 

[Imee_Lee]

@Arthur_Tutt  you've been incredibly helpful! 🌟

The "filter" feature was already in place, so there was no need for me to do it.

The adjustments you made to the script were spot on! 💪

Immense gratitude for your assistance! You truly turned my day around! Thank you so much!! 🙌  🙌 

[Arthur_Tutt]

@Imee_Lee yessssssssssss! Wow this one was a nailbiter, but we made it!! Glad could be of assistance and make it work for you. And thank you for being an action taker and implementing it and making it happen. Best 😎