Sum if dropdown value in SharePoint list

(0) Share

Report

Posted on by KhrystinaM

158

Hello,

I am trying to write a formula that says, "If department = X then sum total steps. Right now, I have the total steps for all departments/associates, but I would like to break it down by department and by associate. How could I accomplish this?

Thank you,

Khrystina

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

AARON_C 2,235 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @KhrystinaM

You need to filter your Sum function. Try this:

Sum(Filter('Fitness Tracker', 'Department Name' = 'Name of dropdown control'.Selected.Value), Steps)

Please tick Accept as solution if the answer is useful.

Thanks,

@AARON_C

Was this reply helpful? Yes No
KhrystinaM 158 on at

Like (0)

Report
Copy link

Link copied!

@AARON_C, that worked. Thank you so much for your help! Wondering if you can help me with another question. I am trying to create an associate dropdown field, but the Associate field name is not in my allowed selection. The field in SharePoint is a Person or Group field. Can I not use that type of field for dropdowns? Associate Name is not in the list below.

Was this reply helpful? Yes No