Forum Discussion
android1
Post Patron
Post PatronIF Custom Column Formula > 1.5
Hi, I'm looking to replace all values in Actual Hours with the values in Scheduled Hours only if the value in Actual is > 1.5 times the size of the Scheduled value. Trying this> if[Actual Hours]*...
That's perfect Eric. That is exactly what I needed. Thank you.
Eric_Zhang
Microsoft Employee
Microsoft Employee
android1 wrote:
Hi,
Thanks for this. I'm getting False as my answers. Could it ba a formatting issue? My columns are in Decimal Number Format.
android1
android1
Are you talking about adding a column in the query editor? You got a "False" because the expression [Actual Hours]=[Scheduled Hours] returns "False". Can you try below expression?
if[Actual Hours]*1.5>[Scheduled Hours] then [Scheduled Hours] else [Actual Hours]
android1Post Patron
Post PatronThat's perfect Eric. That is exactly what I needed. Thank you.