Announcements
Hello,
Is it possible to countifs on CDS Fields（using calculated or roolup）?
I’m doing this on excel but I would like to do same things on CDS.
=COUNTIFS(E:E,E1,O:O,O1,AN:AN,AN1AO:AO,AO1,H:H,"ABC ")
Thank you for your help!
Hey @Anonymous
Can you share more details around this? Will it be done on a canvas app or a model driven app?
In case it is for canvas app, you can use the CountIf function. For more details, please refer: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-table-counts
If you can share more details, we might be able to help you better.
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @Anonymous ,
Yes, you need to create calculated or rollup field.
The formula that you showed is calculated field.
Please note that not all the fields can be used to calculate.
The available data types for the calculated field:
Single line of text
Option Set
Two Options
Whole Number
Decimal Number
Currency
Date and Time
After you create the field successfully, choose it and select "open calculation".
Then you could define calculation in the pop-up window.
Formulas are not the same as in excel.
I suggest you try: If ... equals ... and ...equals ...
Based on your mentioned formula, I think you need to limit fieldname, ID and value.
Here's a doc about how to define calculated field for your reference:
https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/dn832103(v=crm.8)?redirectedfrom=MSDN
If you want to know more about this kind field you could also refer this:
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/calculated-rollup-attributes
Best regards,
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 610
Haque 317
WarrenBelz 315 Most Valuable Professional
