There are two sub reports,one is to count the total pyID & another one is to count of pyID with New status. Two sub reports are working fine. Now I am trying to calculate percentage in main report definition using sub report columns with pxMultiple & px Divide FA. But getting below error. Could anyone tell what is going wrong here?
One of the input values may be null. Try adding another SQL function "ZeroIfNull". In the attached screenshot, I'm getting S1(Fail -count) and S2(Pass - count) from subreports to calculate fail % and pass % .