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)
