Forum Discussion

SammyNed's avatar
SammyNed
Icon for Helper I rankHelper I
5 years ago

Combination Sum

Hi  guys,   Can you please assist? I have 2 tables, Table 1 basically shows how much Customer (Column: Y-ID) spent (Column: Spend) purchasing a certain number of products( Column: Orders) under di...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

"So basically Item a2 and a5 were not part of the items making up the total of R100 spent."

 

WHY NOT? What's the algorithm that lets one determine which were and which were not participating in the cost?

SammyNed's avatar
SammyNed
Icon for Helper I rankHelper I
5 years ago

Unfortunately there's no particular algorhim, just need to know which Items make up the total spend.  Can be random, sometimes all the items add up to the total spend and sometimes only a few items add up to the table spend.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You're out of luck here. To determine which items could constitute the whole (without any other constraints on the problem) you'd need to check all the possible combinations of items. This is not feasible and it's not the kind of problem that PBI has been created to solve.

    • SammyNed's avatar
      SammyNed
      Icon for Helper I rankHelper I
      5 years ago

      Thank you for your feedback. At least now I can stop banging my head against the wall trying to figure something out. ğŸ˜€