cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

If Statement evaluates to '0' when in form mode [1], but works in modes [0,2]

Hi All

I have an IF statement to estimate the value of a hotel booing, so the end user doesn't have to do it.

"If hotel name this, then corp rate * duration = £Gross"

It's nested in another IF (if form mode new do this, else get parent.dafult - see attached screenshot)

But it's not working as expected

 

If I isolate just this part of the formula, it returns the correct amount when the form mode 0 or 2
But returns '0' when in form mode 1?

 

If(ComboBox1.Selected.Result = "Jurys Inn",Duration*84,
If(ComboBox1.Selected.Result = "Future Inns",Duration*80,
If(ComboBox1.Selected.Result = "The Inn at Woodhall Spa",Duration*81))),

Why would form mode [1] stop the formula from evaluating correctly?

 

Thanks all
Vicky

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Very weird, but when I transfered those IF statements to a new label they worked fine

So my formula now reads
"If hotel name this, then 'label8' * duration = £Gross"

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Very weird, but when I transfered those IF statements to a new label they worked fine

So my formula now reads
"If hotel name this, then 'label8' * duration = £Gross"

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Did you miss the call? Check out the recording here!

Top Solution Authors
Top Kudoed Authors
Users online (22,668)