Forum Discussion

spandy34's avatar
spandy34
Responsive Resident
3 years ago
Solved

Time Column Calculation Percentage

I have a table called Procurement_Main_Data and want to create a column that will put a yes  if the Delivered Duration is 10% greater than the Planned Duration otherwise say No   The fields Deliver...
Need Help
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    because you write the measure incorrectly.
    this is how you should write it:

    10% Over =
if([Variance %]>0.1,"Yes","No
Ahmedx's avatar
Ahmedx
Super User
3 years ago
is 10% greater than the Planned Duration
Column = if(MINUTE([Delivered Duration])-MINUTE([Planned Duration]) >10,"YES","NO")
or
Column = if(MINUTE([Delivered Duration])/MINUTE([Planned Duration]) -1> 0.1,"YES","NO")


======

 
  • spandy34's avatar
    spandy34
    Responsive Resident
    3 years ago

    Hi so I need it to say yes if it great than 10% 

     

    eg 10% Over Column 

    Planned Duration = 20 min and the Delivered Duration = 24 minutes 

    10% of 20 minutes planned is 22 so if the Delivered Duration is more than 22 I want it to say Yes, otherwise no

     

    also in the 10% Under Column

    Planned Duration =  20 minutes  Delivered Duration = 12 minutes 

    10% under of 20 minutes planned is 18 so if the Delivered Duration is less than 18 I want it to say Yes, otherwise No