Finance | Project Operations, Human Resources, ...

D365 Financial reporting SUMIF function

(0) Share

Report

Posted on by Community member

Hi, I'm trying to figure out a way to count positive balances to sum in one field and negative balances to sum in another field. Does the SUMIF function work in D365 financial reporting? In excel I can count this with countif. I'm probably not using the correct syntax, tried with a couple of ways already.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Hana Xue Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,
The syntax of this function in ER is as follows:
SUMIF (key name for summing, condition range, condition value)
SUMIFS (key name for summing, condition 1 range, condition 1 value[, condition 2 range, condition 2 value, …, condition N range, condition N value])
The link provides a detailed description of the parameters of this function, please check:
SUMIF ER function - Finance & Operations | Dynamics 365 | Microsoft Learn
SUMIFS ER function - Finance & Operations | Dynamics 365 | Microsoft Learn
Best Regards,
Hana

Was this reply helpful? Yes No
Marikap 29 on at

Like (0)

Report
Copy link

Link copied!

Note, this question is not for ER.

Was this reply helpful? Yes No
Suggested answer

Gaurangkumar Jani 4,546 User Group Leader on at

Like (0)

Report
Copy link

Link copied!

Hi there,

No Sum if function will not work in Financial reporting module.

I would suggest to use print control to do calculation : Advanced formatting options in financial reporting - Finance & Operations | Dynamics 365 | Microsoft Learn

Please let us know if this helps.

Thanks,

Gaurangkumar Jani

Was this reply helpful? Yes No
Marikap 29 on at

Like (0)

Report
Copy link

Link copied!

Good to know that SUMIF is not applicable for financial reporting.

Solved this with adding columns

And printing to rows

Was this reply helpful? Yes No