Data Field Minus 1 formulua

[troop49]

This is my Field values
01
1
2
3
4
5
6
7
8
9
CL
But I need to just minus 1 from the data string for display.if the field is 5 should display a 4.Thanks.

 

[CIBS]

Have you tried a formula like :

{field}-1

 

[troop49]

This is my formula:

({ESYAPPTR.STEP}) - 1

____________
I received this email.

Error Message:
"A number, currency amount, date, time, or date-time is required here.

 

[IanWaterman]

@number
If isnumeric(yourstringfield) then tonumber(yourstringfield)-1 else yourstringfield.

Ian

 

[lbass]

Are the "01" and "CL" part of the series? Try:

if isnumeric({ESYAPPTR.STEP}) then
totext(val({ESYAPPTR.STEP})-1,0,"") else
{ESYAPPTR.STEP}

-LB

 

[troop49]

WOW!!!! this did it.
I didn't understand how to convert a string to a numeric so the math calc could take place.
Thank You!
Thank You!

 

[IanWaterman]

OOPS

LBs solution is correct, I forgot to turn number back to text

If isnumeric(yourstringfield) then totext(tonumber(yourstringfield)-1,0,"") else yourstringfield.

Ian