Small and medium business | Business Central, N...

ERROR An invalid field or attribute has been specified for the 'Format' property.

(0) Share

Report

Posted on by Hoang Ng

295

I got an error when i format the number for the report

An invalid field or attribute has been specified for the 'Format' property.

gTotalRequestAmount := format(1000002, 15, '<Sign><Decimals>');

---------------

gTotalRequestAmount: Text;

Could you please share your experience on this error ?

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

ShanAbeywicrema 948 on at

Like (0)

Report

RE: ERROR An invalid field or attribute has been specified for the 'Format' property.

You can use following syntax, it's simple. But your code also working for me. what is the issue you got?

gTotalRequestAmount := FORMAT(555777.85,15,3);

I got same output in BC

gTotalRequestAmount := FORMAT("Purchase Header"."Amount Including VAT",15,3);

Was this reply helpful? Yes No
Hoang Ng 295 on at

Like (0)

Report

RE: ERROR An invalid field or attribute has been specified for the 'Format' property.

Thanks Shan, Narang

I want to format Amount with thousand separator. I tried to change parameter value in FORMAT but not successful

gTotalRequestAmount := FORMAT("Purchase Header"."Amount Including VAT", 0, '<Sign><Integer Thousand><Decimals>')

Thanks.

Was this reply helpful? Yes No
Suggested answer

ShanAbeywicrema 948 on at

Like (0)

Report

RE: ERROR An invalid field or attribute has been specified for the 'Format' property.

What do you need to achieve. if you use this format string you can specify decimal value. such as 1000002.25

it should be gTotalRequestAmount := FORMAT(1000002.5, 15, '<Sign><Decimals>');

if you don't have decimal use something like this

gTotalRequestAmount := FORMAT(1000002, 15, '<Sign><Integer>');

get idea from following resources

learn.microsoft.com/.../format-function--code--text-

learn.microsoft.com/.../format-property

Was this reply helpful? Yes No
Suggested answer

NAV_with_Narang 2,250 Moderator on at

Like (0)

Report

RE: ERROR An invalid field or attribute has been specified for the 'Format' property.

If your aim is to convert integer/decimal into a text, just use:

Text := FORMAT(Integer);

Was this reply helpful? Yes No