#Div/0 error

Hi,

I have a report which has some measurable objects.The caculation is total cost of goods sold in dollars/total inventory in dollars 

when the both the fields are $0 ,result its displaying is #DIV/0 in the report.
I changed the format and checked but there was no use.
Never came accross this.
Can anyone help me.
Thanks


randyj262004 (BOB member since 2004-04-09)

Recently there was a posting on this. Below is the link. As always mentioned by forum members search is your friend.

https://bobj-board.org/t/29972


arkay9 :india: (BOB member since 2002-12-10)

Thanks, it worked for me.

Solution:
if (denominator<>0) then (nominator/denominator) else 0


randyj262004 (BOB member since 2004-04-09)

Can we do the same modifications in designer?The formatting we did was report level but i want to give the formula in desinger.But this variable is created in reporter.
I gave correct objects formats in desinger but as that variable is created in reporter i’m not aware as how to give in designer
Can anyone help me about this?
Thanks


randyj262004 (BOB member since 2004-04-09)

For Business Objects Designer:
Look at the SQL statement CASE WHEN


Andreas :de: (BOB member since 2002-06-20)

Thanks a lot ,i’l try with that


randyj262004 (BOB member since 2004-04-09)