Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a table as shown below
Here the POC is correct which is 74%, but POC Expression is not populating for all rows (as shown above) what is wrong in my expression here? Attached is file for reference.
= num( aggr((Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Actual]) / Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Projected]) ), [ORA Project Number]) ,'##0%')
thanks
Try this
= num( aggr(NODISTINCT(Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Actual]) / Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Projected]) ), [ORA Project Number]) ,'##0%')
Try this
= num( aggr(NODISTINCT(Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Actual]) / Sum({1<[SCH Task Discipline],[ORA DAY VERSION]={">=$(vCurrentMonthStart)<=$(vCurrentMonthEnd)"}>}[ORA Projected]) ), [ORA Project Number]) ,'##0%')
thank you @sunny_talwar for your valuable time and help