You’re offline. This is a read only version of the page.
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!
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:
If you want to know more about this kind field you could also refer this:
Best regards,
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!
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
