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

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,434 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
StanM 25 on at

Like (0)

Report

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

Was this reply helpful? Yes No
StanM 25 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Join the conversation

Community site session details

Select rows in Electric Reporting based on calculated field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Select rows in Electric Reporting based on calculated field

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates