Hello
I am doing a calculation in the report which does a division of one field over the other. Since the other one is 0 The calculation field shows #DIV/0. Tried putting in a code like this.
If ((<A1>/<A2>)*100) <> 0 Then ((<A1>/<A2>)*100) Where (<Objective ID>=193) else "N/A"
I know my syntax is wrong some place. Dont know where. Can u please tell me where I am doing wrong. I get an error Incorrect Datatype
Thanks
Sri
ddsrini (BOB member since 2004-06-23)