Forum Discussion
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...
because you write the measure incorrectly.
this is how you should write it:10% Over = if([Variance %]>0.1,"Yes","No
Ive added another column called Variance Column. The majority of rows are fine for the 10% Under and10% Over Columns but was wondering why the records filtered in the 10% Over Column is saying 'No' when the Variance % is 1000%. The Variance % field is Percentage format and Data Type Decimal Number
Any ideas? Thank you for your ongoing support