countifs on CDS

(0) Share

Report

Posted on by Community Power Pla...

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!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Verified answer

v-yutliu-msft on at

Like (0)

Report
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,

Was this reply helpful? Yes No