Focal Point
[CLOSED] Inbulit Data Type for Ratio (10:1)

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

March 27, 2012, 05:21 AM
atturhari
[CLOSED] Inbulit Data Type for Ratio (10:1)
Is there any WF function/data type that will convert a number into a ratio value.

For instance, can the numeric value like 10 be converted into 10:1 ?

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


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
March 27, 2012, 07:01 AM
<JG>
Has to be alpha then use concat
EDIT(number 1)||':'||EDIT(number 2);

Use FTOA if you do not want leading zeros
March 27, 2012, 04:31 PM
Waz
Another option is to create a define function


Waz...

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

March 28, 2012, 06:34 AM
atturhari
quote:
Originally posted by Waz:
Another option is to create a define function


Again it has to be converted to Aplha?

I'm using FTOA and able to get comma etc.. It works for me.


WF 7.7.02 on Windows 7
Teradata
HTML,PDF,EXCEL,AHTML
March 28, 2012, 04:28 PM
Waz
What wrong with alpha ?

And the define function would make the code relatively simple.


Waz...

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