Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Here is the example attached. Please help me.
May be like this:
Sum({1<%VisitType={'NPV'}>}%ProcedureCNT)/Sum({1<%VisitType={'NPV'}>}Total %ProcedureCNT)
May be like this:
Sum({1<%VisitType={'NPV'}>}%ProcedureCNT)/Sum({1<%VisitType={'NPV'}>}Total %ProcedureCNT)
Or this if you just want to ignore selection in Department
Sum({<%VisitType={'NPV'}, Department>}%ProcedureCNT)/Sum({<%VisitType={'NPV'}, Department>}Total %ProcedureCNT)
This works for me. I did new that I have to use "1". But did not know where! Pretty Tricky!
Thanks for your help
Pavithra Shetty