Finance | Project Operations, Human Resources, ...

Select rows in Electric Reporting based on calculated field

(1) Share

Report

Posted on by StanM

Hi, all

I have an ER report for populating the general journal template with AR balances from table CustTrans. I have a calculated field called Balance. If the value of Balance = 0, I do not want to write the row to my template.

How can I filter by Balance <> 0

Balance: Calculated field = @.ReportingCurrencyAmount-@.SettleAmountCur: Real

All responses (3)

Answers (0)

StanM 23 on at

Like (0)

Report

Select rows in Electric Reporting based on calculated field

update: I got the Where function to omit the rows where the CREDITAMOUNT = 0.00, but now the excel sheet has the first row's data repeated for the number of rows I should have.

For example: report with non-zero amounts (250) + zero amounts (750) = 1000 rows

now the report has the correct number of rows (250) but they are all a repeat of the first row.
StanM 23 on at

Like (0)

Report

Select rows in Electric Reporting based on calculated field

Hi, @Mohamed Amine Mahmoudi, thank you for the links and information. however, I cannot get the WHERE and FILTER functions to work. My formula for the FILTER is below:

filter(model.Lines,model.Lines.CREDITAMOUNT<>0)

I have a model, and within it, a record list called Lines, and within it, my celles. I do not want to output the line to my Excel sheet if CREDITAMOUNT is 0
Suggested answer

Mohamed Amine Mahmoudi 21,751 Super User 2025 Season 1 on at

Like (0)

Report

Select rows in Electric Reporting based on calculated field

Hi @StanM,

I hope this can help you and give you some hints.

https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/analytics/er-functions-list-where?context=%2Fdynamics365%2Fcontext%2Fcommerce

https://fernitudela.dev/2023/02/08/electronic-reporting-from-scratch-part-4-optimization-of-ger-filter-vs-where-and-debugging-your-er/

Best regards,

Mohamed Amine MAHMOUDI