Query Help

[fvlmasl2]

In Define Result Field how would I check the values of S9RPTSLSC and S9RPTSLSP so that i do not get divide by 0. These fields must be included in the query even if 0. See example below:


FIELD EXPRESSION Column Head
SALESPCT (S9RPTSLSC-S9RPTSLSP)/S9RPTSLSP %Sales


Thanks
Frank

 

[gpzcrasher]

Simple answer - you can't.




--------------------------------
Codito, ergo sum