web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Return Value as 0 if S...

Power Apps

Answered

Return Value as 0 if Sell Amount if equal to or greater than Product Amount

(0) Share

Report

Report

Posted on by Prem4253

669

Hello,

I'm recently creating a PowerApps form, where I'm looking for multiple solutions. Of which below is one of the requirement.

Return Value as 0 if Sell Amount if equal to or greater than Product Amount (see below screenshot)

I need to have a logic in Actual Amount field to return 0, If Sell Amount is greater than Product Amount.

And if Sell Amount is less than Product Amount - logic should be Product Amount - Sell Amount.

Please advise. Thanks!

Prem

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Daniel Bocklandt 5,137 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey @Prem4253,

Try this:

If(Value('Sell Amount') > Value('Product Amount'),0,Value('Product Amount') - Value('Sell Amount'))

You can olso replace the columnnames with the field names.

If this solvede your porblem please accept it as solution so others can find it as well.
If it helped in any other way consider liking it so we can keep supporting eachother.

Was this reply helpful? Yes No
Suggested answer

Prem4253 669 on at

Like (0)

Report
Copy link

Link copied!

@DBO_DV

Thanks! this did the trick.

Thanks for your quick response. Much Appreciated.

Was this reply helpful? Yes No

Join the conversation