 Divided by Zero error [message #148138] |
Tue, 22 November 2005 21:57  |
sourajit_seth
Messages: 38
Registered: November 2005
Location: India
|
Member |
|
|
Hello
In report I have create one percentage column, choosing the option "Grand Total for each column". It is showing the percentage of each value for a column (say x). If sum(x) > 0, it is working fine, but in case all values of x are 0 , it is showing "#DIV/0!" (zero divide error) , since the denominator is 0 (sum(x)=0). So I want to show "N.A." or any text or 0 , instead of "#DIV/0!. Let me know the way.
Thanks in advance
Sourajit
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
