Share
Report
39Hi,
I am currently working on customizing the Microsoft expense report template to suit our specific requirements. I have encountered a challenge with one of the formulas that I'm using, and I'm seeking your assistance to resolve this issue.
Initially, I had been using the following formula: which was working absolutely fine however showing complete record which is available on the SharePoint List
"$" & With({Item:LineItems},If(Sum(Filter(Item,ReportID.Id in OpenReports.ID),Cost)>0,Text(Sum(Filter(Item,ReportID.Id in OpenReports.ID),Cost),"[$-en-US]#,###.00"),0))However, in order to further tailor this formula to our needs, I have attempted to implement the following modification:
"$" & With( {FilteredItems: Filter(LineItems, ReportID.Id in OpenReports.ID && CSE_Name = User().Email ) }, If( Sum(FilteredItems, Cost ) > 0, Text(Sum( FilteredItems, Cost ),"[$-en-US]#,###.00" ), 0 ))Regrettably, this modified formula is currently returning a zero value along with a delegation error.
I kindly request your expertise and guidance in helping me build a formula that effectively filters the data based on the logged-in user and fulfills our requirement.
Thanks & Regards,
Sanket
All responses (
Answers (
