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

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

10% Over =
if([Variance %]>0.1,"Yes","No
spandy34's avatar
spandy34
Responsive Resident
3 years ago

Thank you thats done it.  Really appreciate your help as always:)