Aggregation syntax not giving correct data

[georgegv]

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

[vmoreno2605]

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

[georgegv]

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.