replace packed data with '-'

Focal Point

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3227036336

September 20, 2013, 09:55 AM

souji

replace packed data with '-'

Hi All,

I have a report where in i have to replace a particular column with '-' which is packed decimal.
example i have a value 10.22 which we need to replace with '-' based on a condition otherwise the value should remain same as 10.22.

Can some one give me any idea.

WebFocus 7.1.4 xp html,excel,pdf

September 20, 2013, 10:11 AM

TexasStingray

I believe you will have to put everything into an ALPHA field and if the condution is true then put a - in it, else use FTOA to convert it to ALPAA and then TRIM off leading zeros.

This message has been edited. Last edited by: TexasStingray,

Scott

September 22, 2013, 05:51 PM

Waz

Another optionis to use MISSING ON, then for that condition set the value to MISSING and make sure you SET NODATA = '-'

Waz...

Prod:	WebFOCUS 7.6.10/8.1.04	Upgrade:	WebFOCUS 8.2.07	OS:	Linux	Outputs:	HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!