Expense App for manager screen. Pending and Approved amount

[WeiMingLeong]

Hi all, thank you for taking your time to see this message.

i am trying to do a expense app for office to use.
It will contain a employee screen and Manager Screen.

There is 2 sharepoint list, 1 expense list 1 lineitem list.

in the Manager Screen, i have done adding the filter to filter ApproverNamer on the OnVisible, set screen to Pending button to show only pending status..

and Hide Open tab so that it will not show their own ongoing claim.

Set(ExpenseStatus,"Pending");
Set(ExpenseSorting,Descending);
Filter(Expenses, User().FullName=ApproverName.DisplayName);
ClearCollect(OpenReports,Filter(Expenses,Status.Value = "Open").ID);
ClearCollect(ApprovedReports,Filter(Expenses,Status.Value = "Approved").ID);
ClearCollect(PendingReports,Filter(Expenses,Status.Value = "Pending").ID);
Refresh(Expenses);
Refresh(LineItems)

 How can i filter the Pending and Approved amount to be showing the amount the is for the manager to approve or approved.
this is what it have been set

"$" & If(Sum(Filter(LineItems,Text(ReportID) in PendingReports.ID),Cost)>0,Text(Sum(Filter(LineItems,ReportID in PendingReports.ID),Cost),"[$-en-US]#,###.00"),0)

[WeiMingLeong]

anyone can help?

[AJ_Z · Accepted solution]

I recommend Sum on the values brought back by the galleries as you advised delegation would not be an issue. This should be a nice quick solution 🙂

let me know if it works

[WeiMingLeong]

Hi @AJ_Z ,

This work, Thank you for your help again.!

[AJ_Z]

always happy to help