Forum Discussion

android1's avatar
android1
Icon for Post Patron rankPost 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.

     

     

Anonymous's avatar
Anonymous
Not applicable
10 years ago

I think you need the else 

 

if[Actual Hours]*1.5>[Scheduled Hours]then[Actual Hours]=[Scheduled Hours] else [Actual Hours]

 

HTH

Raven

 

 

    • android1's avatar
      android1
      Icon for Post Patron rankPost 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
        Icon for Microsoft Employee rankMicrosoft 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]