Unanswered

Calculate the percentage of days less than or equal to 30

(0) Share

Report

Posted on by CircusFlea

I am creating an app and I want to display the metric of what % of non-conformances are closed on time. I have a calculated column 'Days Open', the days between 'Date Open' and 'Date Closed'. I used this column to show the metric for the average # of days an NC was open, but I am not having any luck with getting a percentage. Based on searches, I have tried using variations of

Percent = If( Sum( CPARIndex.'Days Open' IsBlank() = False ) > 0, // Check for empty list

Round( ( Sum(If(CPARIndex.'Days Open' <= 30, 1, 0)) / Sum( CPARIndex.'Days Open' IsBlank() = False ) ) * 100, 2 // Round to two decimal places (optional) ), 0 // Display 0% if the list is empty )

Unfortunately, it doesn't seem to be accepting any anything I put after the list name. Any help would be much appreciated!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Mitanshu 1,650 Moderator on at

Like (0)

Report
PercentageLessThan30Days = CountIf( data_source, DaysOpenColumn < 30 ) / CountRows(data_source) * 100

Can you try above?

Reference: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-table-counts

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
CircusFlea 11 on at

Like (0)

Report

That did not seem to work. I am not worried about the delegation warning as we will not be hitting that limit

Was this reply helpful? Yes No
BhaskarDhone 1,392 Super User 2025 Season 2 on at

Like (1)

Report
Percent = Round((CountIf(NCIndex, 'Days Open' <= 30 && 'Date Closed' <> Blank()) / CountRows(NCIndex)) * 100, 2)

try this

Was this reply helpful? Yes No
CircusFlea 11 on at

Like (0)

Report

I am not getting a calculation to show up, although this is the first time it has actually recognized my column names

Was this reply helpful? Yes No