cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NewBee117
Advocate V
Advocate V

Formula does not work when value is zero

What to do to get this formula to work when "Value(txt_WeeklyAdjustment.Text)" is zero? It calculates correctly with any other numbers, just not zero. The actual formula = Adjustment: gal_Monthly.Selected.Adjustment + Value(txt_WeeklyAdjustment.Text)

 

1 ACCEPTED SOLUTION

Accepted Solutions
rsaikrishna
Dual Super User
Dual Super User

@NewBee117 

 

You can place following formula for Adjustment:

if(Value(txt_WeeklyAdjustment.Text) > 0,gal_Monthly.Selected.Adjustment + Value(txt_WeeklyAdjustment.Text), gal_Monthly.Selected.Adjustment )

 

Please give a try and let me know if you still have the same issue.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

View solution in original post

3 REPLIES 3
rsaikrishna
Dual Super User
Dual Super User

@NewBee117 

 

You can place following formula for Adjustment:

if(Value(txt_WeeklyAdjustment.Text) > 0,gal_Monthly.Selected.Adjustment + Value(txt_WeeklyAdjustment.Text), gal_Monthly.Selected.Adjustment )

 

Please give a try and let me know if you still have the same issue.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

View solution in original post

eka24
Super User
Super User

Consider this:

Coalesce(gal_Monthly.Selected.Adjustment) +Coalesce(txt_WeeklyAdjustment.Text)
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
NewBee117
Advocate V
Advocate V

@eka24 your suggestion does not work.

@rsaikrishna I modified your formula, it is now working. Thanks.

 Adjustment: If(
Value(txt_WeeklyAdjustment.Text) <> 0,
gal_Monthly.Selected.Adjustment + Value(txt_WeeklyAdjustment.Text),
gal_Monthly.Selected.Adjustment - gal_Weekly.Selected.Adjustment
)

Btw, the way it treats zero, is it a bug or "By Design?". I like to know the reason if it is "By Design".  🙂

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,838)