nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

PercentSum Problem

jlux33

I have a dataset that returns data similar to (Note: dashes are to indicate field separation): Type - Daily - Weekly - Monthly - YearlyT1 - 0 - 10 - 20 - 30T2 - 0 - 15 - 25 - 35T3 - 0 - 20 - 30 - 40 When I type to do PERCENTSUM for the four colums, the Daily column will throw an error and the report fails. The business is sometimes closed, so all rows for Daily = 0. How can I get PERCENTSUM to return a 0 and not an error? Jim

Find more posts tagged with

Comments

BRM

I haven't used PERCENTSUM very much so I don't know why it would be failing but if Daily is always 0 and thus the % sum is always 0 then can you just hard code that (i.e. with a label) so your report looks the way it should but doesn't fail?

bgbaird

You could also define aggregation datapoints for sum and count of each column, then set a third aggregation point using the safeDivide() function, or an if/else to protect your execution. Brian

jlux33

The Daily amount isn't "always" zero, only when the store(s) are closed, so can't hard code a value. Aggregations data points for sum and count won't work. The PERCENTSUM function tells you what percent the row is of the column total. An aggregation on a row will just equal the row, so it won't work. Thank for the thoughts. Jim