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