Forum Discussion

android1's avatar
android1
Post Patron
10 years ago
Solved

IF 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]*...
Need Help
  • android1's avatar
    android1
    10 years ago

    That's perfect Eric. That is exactly what I needed. Thank you.

     

     

android1's avatar
android1
Post Patron
10 years ago

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

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    10 years ago
    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]


     

    • android1's avatar
      android1
      Post Patron
      10 years ago

      That's perfect Eric. That is exactly what I needed. Thank you.