Unanswered

SUMIFS AND MONTH FUNCTION

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hey guys, been having a hard time finding answers.

I have a datatable on my powerapps and i just want the sum of the amount based on 2 columns - ID code and Month which should be the same as the current month.

i dont know how to write or code the sumifs
and use Month on the column (date) to match the current date

This is the formula i made:

If(IsBlank(TextInput3_Searchbox)," ",1000-Sum(Filter('Employee Discount | Discount Data', TextInput3_Searchbox.Text= 'Employee Code'&& Month('Transaction Date') = Month(Today()),Discount)

HELP!!!!!!!!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (0)

Sort by

PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Assuming your logic is fine. Does below code works in your case ?

If(IsBlank(TextInput3_Searchbox) ," ", 1000-Sum(Filter('Employee Discount | Discount Data', TextInput3_Searchbox.Text= 'Employee Code'&& Month('Transaction Date') = Month(Today()),Discount)))

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 the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Sadly does not 😞

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

What is the error message you getting ?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, it just says error in formula, please try revising...

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Your two possible outcomes are different types (Text and Numeric) and you also had a bracket in the wrong place - try this

If( IsBlank(TextInput3_Searchbox), 0, 1000- Sum( Filter( 'Employee Discount | Discount Data', 'Employee Code' = TextInput3_Searchbox.Text && Month('Transaction Date') = Month(Today()) ), Discount ) )

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 the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi, i used it and there isn't any error showing.. but it doesn't recognize the Transaction date (shown on the table as "Saturday, August 21, 2021" as August I guess? because it still showing "1000"

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Anonymous ,

What type of field is 'Transaction Date' and what is your Data Source?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz its sharepoint and its a date

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

There is something else wrong here - if 'Transaction Date' is a date field in SharePoint, then

Month('Transaction Date') = Month(Today())

will show all the records with the current month with one proviso - Month() is not Delegable, so you will not get all the records on large data sets - how big is you list?

Also what code are you using to display the date the way you have it in the screenshot?

Was this reply helpful? Yes No
WarrenBelz 155,463 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

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 the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No