Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
| Product | Source | Destination | Cost | Cost 2 | Total Cost |
|---|---|---|---|---|---|
| Handbag | A | A1 | 0 | 5 | 5 |
| Handbag2 | B | B1 | 10 | 10 | 20 |
| Handbag3 | C | C1 | 20 | 15 | 35 |
| Handbag4 | D | D1 | 30 | 10 | 40 |
| Handbag5 | E | E1 | 40 | 20 | 60 |
Right now, I'm using the above example where I'm using =FirstSortedValue(Source, [Total Cost],1)
Is there any way that if my data had 0 as one of the cost, not to include it as the cheapest source?
For example, the cheapest source would be B, C, and D.
Thanks for your help!!