LIST_LINE numeric format string

gijsvb

Hi,

I have a list_line command like:
Abonnement.Pakketbeschrijving=LIST_LINE(Abonnement.Pakket,'ORDER BY PakketOptie.Pakket.Volgnummer',':',' ','CodeAGF','OptionAmount,0.00')

I try to present the OptionAmount with two decimal digits f.i. 15.00. The resulting string contains amounts with one decimal digit, like 15.0. What should be the correct format string to get two decimal digits?

Regards,

Gijs.

customaware

Have tested but try....

CodeAGF','OptionAmount@0.00')

CodeAGF','OptionAmount@n')

gijsvb

Hi Mark,

Thanks for your response, but this doesn't help. Using a @ sign, the attribute name is no longer recognized. I also tried leaving out the optional format specifier, but this gives the same result with only one decimal digit.

When shown on a form, the 'OptionAmount' is correctly displayed with two digits, but in the list_line function it isn't working.

Regards,

Gijs.

customaware

Hi Gijs,

What is the format you have of the Attribute OptionAmount in the Business Object?

gijsvb

Hi Mark,

The format of OptionAmount is 0.00 (Type= Number)

Regards,

Gijs.

ACDC

Try this:
Object.Number,#0.0

gijsvb

Hi,

Thank you for response, but it's not a solution. Still the same effect, only one decimal digit.

Regards,

Gijs.

Jaymer

will it accept a function?

'CodeAGF',AS_STRING(OptionAmount)
instead of
'CodeAGF','OptionAmount'

if so, then you can do
AS_NUMBER(AS_STRING(OptionAmount),'#.##')

tford

I was thinking the same as Jaymer. If it won't accept, of course you could take a similar approach by creating another attribute & using Jaymer's rule to populate the new attribute.

gijsvb

Hi,

LIST_LINE doesn't accept functions as a parameter it seems, I get the message:
com.bas.shared.ruleparser.ParseException Invalid parameter identifying attribute name in LIST_LINE function

Thanks for your response however.