cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Anonymous
Not applicable

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

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
Highlighted
Anonymous
Not applicable

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

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,266)