Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / Select rows in Electri...
Finance forum
Suggested answer

Select rows in Electric Reporting based on calculated field

(1) ShareShare
ReportReport
Posted on by StanM 19
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
Categories:
Other
Financial Management
  • StanM Profile Picture
    StanM 19 on at
    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 Profile Picture
    StanM 19 on at
    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 Profile Picture
    Mohamed Amine Mahmoudi 9,314 Super User 2024 Season 2 on at
    Select rows in Electric Reporting based on calculated field

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans