Skip to Content
0

#Div/0 Error in Percentage

Mar 22 at 11:33 AM

15

avatar image
Sudarsan P

Hi,

i am dividing two number

-350/500

when i take the percentage i am getting #Div/0.

Instead of #Div/0 i want to show as n/a

capture.jpg

capture.jpg (12.4 kB)
SAP BusinessObjects - Web Intelligence (WebI)
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
avatar image
AMIT KUMAR Answered
Mar 22 at 11:35 AM
1

=if(iserror(variable)) then "n/a" else [variable]

Show 3 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Sudarsan P
Mar 22 at 11:39 AM

its became string and i cannt do percentage. even though i have writeen the formula as below

=If(IsError([Rtn% Qty])) Then "n/a" Else FormatNumber(([Rtn% Qty]);"0.00%")

capture1.jpg

capture1.jpg (13.5 kB)
0
AMIT KUMAR
Sudarsan P
Mar 22 at 11:42 AM

if you need to display "n.a" then obvious it's going to be convert in the string.

replace "n.a" with 0 and try.

0
Sudarsan P
Mar 22 at 11:51 AM

i dnt want to display 0

0
Comment