use a computed column and create a global function
GLOBAL FUNCTION
long f_DivideBy(long al_value)
RETURN al_value/gnv_app.of_GetDivideBy()
COMPUTED FIELD
f_DivideBy(column)
GNV_APP
long of_GetDivideBy()
RETURN il_DivideBy
GNV_APP
(none) of_SetDivideBy(long al_value)
il_DivideBy = al_value
> -----Original Message-----
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: Sunday, August 01, 1999 1:55 PM
> To: [EMAIL PROTECTED]
> Subject: PFCSIG Dividing by 1000
>
> Another non-pfc question (I think)
>
> I have to build a general routine to convert all numeric fields in my dw
> to
> thousands and millions (i.e. divide all numbers by 1,000 or 1,000,000 or
> multiply) . Anybody have a 'neat' solution ???
>
> Thanks
>
> David Lerner
>
>
>
> > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS,
> ADDRESS
> > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help
> pfcsig
> > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
