Skip to Content
Former Member
Feb 18, 2010 at 08:02 PM

Percentage issue with column



I am having issues with a column in my report I am developing. The formula for the column is:

=Sum([Condition1] In([Condition2]))/Sum([Condition1] In( [Condition3]))

Now, we already have a version of this report in production. The version I am developing shows 100.00% for data in all cells of this column. The prod version shows the correct varying percentages for each row (74.56%, 3.5%, etc.). Any suggestions as to how I can produce the correct data on my dev report? The formatting and formula are the same in both prod and dev.

Thank you!