Skip to main content

Notifications

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 4,442 User Group Leader on at

Helpful resources

Quick Links

Contextual content recommendations & SharePoint Q&A

Instantly access relevant sales materials…

Beyond the DRA Cloud Label Printing

Explore cloud-based label printing within Dynamics 365…

HR Infrastructure Customer merge

Important considerations for HR Customer migrations…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,418 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 223,631 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,142

Featured topics

Product updates

Dynamics 365 release plans