Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a relative frequency using the AGGR function. I have a snapshot of the data as it is exported to Excel.
I would like to divide each count by the total count for each product code. All rows other than a randomly chosen row are showing up as missing.
=Count(AcctNum)/Count(Total <ProductCode> AcctNum)
Use Distinct if necessary..
=Count(AcctNum)/Count(Total <ProductCode> AcctNum)
Use Distinct if necessary..