web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps operator precedence

Power Apps

Answered

operator precedence

(0) Share

Report

Report

Posted on by JeanFred

32

Hi !

the question may sound obvious but maybe because I can not find out the exact english expression I can't succeed to find an answer

here is my question

I do have this code

Sum(
Filter(
'PMO 2022';
BUSINESS1>=0);'BUDGETQ1'+'BUDGETQ2'+'BUDGETQ3+'BUDGETQ4'*BUSINESS1/100)

But ! I would like not to operate the multiplication by the last BudgetQ4 but with the entire sum !

in normal mathematic it would have been like that

(BUDGETQ1+BUDGETQ2+BUDGETQ3+BUDGETQ4)*BUSINESS1/100

can you tell me how to first do the sum and then multiply it by "business1)

many thx

JeanFred

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

shoog 2,164 on at

Like
a
(0)

Report
Copy link

Link copied!

You can use the brackets, just like in mathematics, to force precedence.

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JeanFred

Edited : with your data
With( { _Item: Filter( 'PMO 2022'; BUSINESS1 >=0 ); _sum: (BUDGETQ1 + BUDGETQ2 + BUDGETQ3 + BUDGETQ4); _divide: (BUSINESS1/100) }, _sum + _divide )

Was this reply helpful? Yes No
JeanFred 32 on at

Like
a
(0)

Report
Copy link

Link copied!

gosh I feel very ashame ! thank you to take the time to answer such a dumb question 🐵

Was this reply helpful? Yes No

Join the conversation