I'm having a lot of problems with this. I have some fields for people to put data in two areas single item and multi item. The single item works fine but I'm struggling with the multi-item one. Here is what I want to do. They input information and the app does the following calculations.
| Item | Units | Time | Reward | Units x Reward | % of Total |
| A | 1 | 2 | 1 | 1 | 1% |
| B | 10 | 4 | 0.5 | 5 | 3% |
| C | 100 | 6 | 0.25 | 25 | 17% |
| D | 1000 | 8 | 0.12 | 120 | 80% |
After they finish updating all the items, for all multi-items I want to patch in the highest units and time.
| Item | Units | Time | Reward | Units x Reward | % of Total |
| A | 1000 | 8 | 0.2 | 200 | 14% |
| B | 1000 | 8 | 0.3 | 300 | 21% |
| C | 1000 | 8 | 0.4 | 400 | 29% |
| D | 1000 | 8 | 0.5 | 500 | 36% |
I know the formula is something like ForAll(Filter(Data,MultiItem = True),Patch(Data,???,Max(Filter(Data1,Multipack = true),Units))).
Edit: I'm now thinking UpdatedIF is better suited for this. I'm playing with that right now.
Edit#2: UpdateIF works. I'm good.
