Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am using the following syntax with aggr function :
aggr(count(PracticeNo),(ScriptPeriod))
It is giving me an partial correct output . It is not filling all the cells on the report.
Attaching screenshot to show output
Please help
I don't know what the expected result is; however, i imagine what you want to do so, try this:
Sum(aggr(count(PracticeNo),(ScriptPeriod)))
i hope this helps
Hi
Thanks however I still get gaps in my data output.
I have attached a screenshot of my output. You will note that blue stars.