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
according to your table, there will be "NO" everywhere, I correctly understood your goal?
There is a lot of data.
I want to create a column that will put a yes if the Delivered Duration is 10% greater than the Planned Duration otherwise say No and call it 'over 10%' also
I create a column that will put a yes if the Delivered Duration is 10% less than the Planned Duration otherwise say No and call it 'under 10%'
