Hi everyone,
I'm a Power Apps newbie who's been building a practice model-driven budget app for travel approval. It has two tables:
- Budget Headers: Tracks trip details like traveler name, destination, and date.
- Budget Items: Lists individual expense items with their expected cost.
Obviously, one budget will have multiple items. Here's my challenge:
I want a "Total Cost" field in Budget Headers that automatically reflects the summed cost of all its corresponding items in Budget Items. Ideally, this should be a real-time calculation, where adding a new item instantly updates the Total Cost in the associated budget.
Can someone guide me on how to achieve this dynamic total cost calculation?
