Sum of Value with Distinct on another category

Karineyumi — Wed, 12 Oct 2022 17:48:30 GMT

Hey guys,

I really need your help..

I have this case:

Basicaly the Booking is the key that unites both databases (the Main database has a lot more columns then the example), and for one particular table i need to have the Sum of the Value Revenue but distincting the Bookings from the Main database.

I cannot separate the databases from each other, because I use information from the main database as well.

i tried many formulas using aggr/sum/distinct, but nothing has worked.

really appreciate your help!

thanks

Re: Sum of Value with Distinct on another category

BrunPierre — Wed, 12 Oct 2022 19:32:28 GMT

Perhaps this

=Sum(Aggr(Only([Value Revenue]),Booking,[Value Revenue])

Re: Sum of Value with Distinct on another category

Karineyumi — Wed, 12 Oct 2022 21:20:30 GMT

Perfect, it worked!

Thank youuuuuuuu

topic Re: Sum of Value with Distinct on another category in App Development

Sum of Value with Distinct on another category

Re: Sum of Value with Distinct on another category

Re: Sum of Value with Distinct on another category