Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
PercentSum Problem
Migrateduser
<p>I have a dataset that returns data similar to (Note: dashes are to indicate field separation):</p><p> </p><p>Type - Daily - Weekly - Monthly - Yearly</p><p>T1 - 0 - 10 - 20 - 30</p><p>T2 - 0 - 15 - 25 - 35</p><p>T3 - 0 - 20 - 30 - 40</p><p> </p><p>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.</p><p> </p><p>How can I get PERCENTSUM to return a 0 and not an error?</p><p> </p><p>Jim</p>
Find more posts tagged with
Comments
There are no comments yet