PowerApps - To calculate total income and expenses

(0) Share

Report

Posted on by Nbz78

Hi all. I have an app to record my department's fund. There's a column namely "AmountPaid". For any payments by the staff, I will record the info/data into the column.

My question is, I want to get the total sum for "AmountPaid", and next to get total sum for "Expenses". My aim is to get [AmountPaid - Expenses] to obtain their nett balance.

For the expenses, do I need to create a new sharepoint list just to record the expenses? As of now, I still haven't created any column to insert data for Expenses.

Thank you so much!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Nbz78,

If you want to get the nett balance, absolutely you need to record the expense.

You need to create a new column to save the expense, so that we could use the following formula to get the nett balance:

Sum(Fund,AmountPaid)-Sum(Fund,Expense)

Was this reply helpful? Yes No
Nbz78 64 on at

Like (0)

Report

Hi, thanks for helping!

Was this reply helpful? Yes No