I could use some help on this if statement:
if (field1.rawValue == 0)
{
this.rawValue = 0
}
else if (field2.rawValue == 0)
{
this.rawValue = 0
}
else (field2/field1)*100;
I know that the solution is most likely simple, but I'm not sure how to get this to work. The result I want is if field 1 is 0 or field 2 is zero then this field should equal field 2 divided by field 1 and the result multiplied by 100. These fields are all located within the same subform. I have also tried the following formCalc with no success either:
if(field1>0)|or(field2>0)then(field3=0)else*((field2/field1)*100)endif
Any help would be greatly appreciated.