question in wrkqry

[mksamy_99]

hi all.
Is it possible to do calculation of percentage of a given field through wrkqry?

muthu

[DeadManWalks]

I think this is what you mean.

                              Define Result Fields  
                                                    
 Type definitions using field names or constants and
   Operators:  +, -, *, /, SUBSTR, ||, DATE...      
                                                    
 Field       Expression                         Colu
 PERCENT     (cbhboy/cbhand) * 100 

When you run it you get this;

 Sku Number  On hand B.O.Y.  On hand            PERCENT  
     13607            3           3             100.00  
     13615            0           0   +++++++++++++++++ 
     13623       299086-     305007-             98.06  
     13631            0           0   +++++++++++++++++ 
     13649            0           0   +++++++++++++++++ 

The '++++' if for the devide by zero.