Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

calculation result plus text

Avatar

Level 4

I would like a field to display the result of a calculation, a space and then the word “Days”.

I’m using the following calculation in TextField3:

form1.#subform[0].TextField3::calculate - (FormCalc, client)

If (TextField1 > 0) then

TextField2/TextField1

endif

example: TextField2 = 10, TextField1 = 2, TextField3 result is 5.

How do I get TextField3 to display 5 Days?

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi,

If you change TextField3 to a numeric field you will be able to use the display pattern of

num{zzzzzzzzzzzz9' days'}

or if you want fractions of days then

num{zzzzzzzzzzzz9.99' days'}

Regards

Bruce

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Hi,

If you change TextField3 to a numeric field you will be able to use the display pattern of

num{zzzzzzzzzzzz9' days'}

or if you want fractions of days then

num{zzzzzzzzzzzz9.99' days'}

Regards

Bruce