Answered

Sum not calculating correctly

(0) Share

Report

Posted on by vffdd

1,257 Super User 2024 Season 1

I want to calculate based on one fixed field and another with a varying text. However it is not calculating correctly. Here is what I am using

Sum(
 ForAll(
 'MyDataSource',
 Status = "New" And UpdatdStatus = "one" || "two" || "three" || "four" 
 ),
 Value
)

but it will only sum those that are "New" and "one" not "New and "two" etc.. so the || seems to be discounting the first requirement of Status.

How should I word this to calculate all items with the Status of "New" and then with an UpdatedStatus of one, two,three etc..

TIA

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
When you are using || (OR), you are saying to the interpreter that

(status is new and updatdstatus=one)

or two or three or four

so it doesn't know that you are referring to updatdstatus.

You should format it like this:

Sum( ForAll( 'MyDataSource', Status = "New" And ( UpdatdStatus = "one" || UpdatdStatus = "two" || UpdatdStatus = "three" || UpdatdStatus = "four" ) ), Value )
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks yeah figured that and have updated but still only calculating the first updated status even doing it as above.. ?
iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hey, I just realised, you are using a ForAll? but what action are you doing For All of the datasource?

What is the name of the field you are trying to sum?

Are you trying to get a count of the rows where status new and updatdstatus=1/2/3/4?

If just trying to get the number of rows then:

CountRows( Filter( 'MyDataSource', Status = "New" And ( UpdatdStatus = "one" || UpdatdStatus = "two" || UpdatdStatus = "three" || UpdatdStatus = "four" ) ) )
vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

I'm trying to get how many items have a status of new AND an Updated Status of either, one or two or 3.. (counting each of them)

I can't use Countrows as I get a delegation warning plus it says the countrow operation is not supported by this connector..

The forall and sum gets around the delegation issue but it only reads the first Updatedated Status
Verified answer

vffdd 1,257 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Anyway I resolved it.. probably not the cleanest way ! but it gives me the answer I want..

Sum( ForAll( 'MyDataSource', Status = "New" And UpdatdStatus = "one" ||And UpdatdStatus = "two" ||And UpdatdStatus = "three" ||And UpdatdStatus = "four" ), Value )