Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Select rows in Electri...
Finance forum
Suggested answer

Select rows in Electric Reporting based on calculated field

Posted on by 15
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
  • StanM Profile Picture
    StanM 15 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 15 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 8,080 User Group Leader on at

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,768 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,985 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans