Formula Help - Adding a defined value to field

[Former Member]

I have a database field that needs to have 7000 added to it so for instance the database field might contain the value 0234 I want this to be turned into 7234. Does anyone know how to achive this?

[Former Member · Accepted solution]

Hi,

Create a Formula

WhilePrintingRecords;
numberVar add;
add:={databasefield}+7000;
add;

if datbase fld is not a number thn convet it to number by function tonumber(database fld)

Regards,

Harry.

Edited by: Harry Hilton on Feb 18, 2009 7:50 AM

[Former Member · Accepted solution]

Hi Harry,

I tried your formula but I get an error message string expected "here" it highlights the 7000.

WhilePrintingRecords;

numberVar add;

add:={COMPNT.Sys}+7000;

add;

[Former Member · Accepted solution]

Alexander,

Try this:

WhilePrintingRecords;
numberVar add;
add:=tonumber({COMPNT.Sys})+7000;
add;

Regards,

Zack H.

[Former Member · Accepted solution]

Zack! Thank you very much both of your posts worked!

Thanks for your quick reply.

[Former Member]

Hi..

Just add 7000 to field this will give you the added value like

+7000

Thanks,

Sastry

[Former Member]

Alexander,

If your database field is a fixed length of 4 digits, you can create a simple formula as such:

"7"+right({4digit.field},3)

This will change the first character of each field to 7.

I hope this helps.

Regards,

Zack H.