Hi AllI 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 2But 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  stop the formula from evaluating correctly?
Go to Solution.
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
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand