cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DUSK Occasional Visitor
Occasional Visitor

Sum valors just if the sum itself does not exceed a given number (525000)

I have the next values:

Costo
 Q 353,000.00
 Q 251,000.00
 Q 325,000.00
 Q 217,000.00
 Q 450,000.00
 Q 400,000.00
 Q 250,000.00
 Q 190,000.00
 Q 250,000.00
 Q 180,000.00
 Q 250,000.00
 Q 260,000.00
 Q 260,000.00
 Q 400,000.00
 Q 380,000.00
 Q 390,000.00
 Q 480,000.00
 Q 360,000.00

 

but i need to get the max sum of this numbers always as the sum itself equals 525,000 or minus, tried a lot of diferent ways but don't get it

1 REPLY 1
Super User
Super User

Re: Sum valors just if the sum itself does not exceed a given number (525000)

@DUSK you question is not very clear what you are asking for. can you please rephrase or provide more details.





Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Kudos Help Smiley Happy
Connect with me on Linkedin. Feel free to email me with any of your BI needs.