How can I Count true or false for long datasets?

(0) Share

Report

Posted on by HectorOlivos

411

Hello Community!

I'm having trouble with a bit column from sql, that column marks if a piece is scrap or not if its 1 it counts the piece as Scrap if it's 0 it counts the pieces as OK

I want to count all the rows that have a 1 and 0 from my column only from today date, is it possible to do that?

Currently Im using this formula but it´s not working:

CountIf(
 FORD_Characteristics,
 FechaDetección = Text(Today(), "[$-en-US]yyyy-mm-dd") && (Scrap_PzaBuena = 0)
)

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @HectorOlivos ,

Could you try updating the formula with a DateValue function if FechaDetección is being read as a Date?

CountIf( FORD_Characteristics, Scrap_PzaBuena = 0, FechaDetección = DateValue(Text(Today(), "[$-en-US]yyyy-mm-dd")) )

Assuming FechaDetección is Text, are you sure the format of "yyyy-mm-dd" matches that column?

On a related note, direct filters on dates are not delegable with SQL server. There is a workaround documented by Microsoft linked below:

https://learn.microsoft.com/en-us/connectors/sql/#power-apps-functions-and-operations-delegable-to-sql-server

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
HectorOlivos 411 on at

Like (0)

Report
Copy link

Link copied!
Hi @Amik,

Thanks for the answer. However it's not working at all:

in top labels I'm using the formula you helped me with, but its returning 0

The labels below where is a 4 and 1996 I use this formula:

Sum( FORD_Characteristics, Scrap_PzaBuena = true )

from the formula you gave me I removed this part and worked 🙂

FechaDetección = DateValue(Text(Today(), "[$-en-US]yyyy-mm-dd"))

I think the date column is causing the issue

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@HectorOlivos as mentioned, dates are not delegable with SQL server.

Consider using:

ALTER TABLE myTable ADD DateAsInt AS (YEAR([date]) * 10000 + MONTH([date]) * 100 + DAY([date]))

Then filter on that number column instead.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
HectorOlivos 411 on at

Like (1)

Report
Copy link

Link copied!

Yep, now it worked thanks

Was this reply helpful? Yes No