Reading formula result as string

[dcalderon]

Hello All,

I have looked around the discussion boards for an answer with no luck. I have a formula as follows:

REPT("|",{Line Count})

When I use this, it just gives me an #ERROR! as the entry in the field. Entries with a zero in "Line Count" are blank.

I am not sure what I am doing wrong. "Line Count" is just the result of number (from another field) being divided by 10,000. Is it an issue that it is a formula field?

Any help that anyone can provide would be greatly appreciated. Thank you!

[Sho · Accepted solution]

Hi @dcalderon.

The REPT function seems to allow only integers.
Adding INT or ROUND functions eliminates the error.

REPT("|",INT({Line Count}))
REPT("|",ROUND({Line Count},0))

[dcalderon]

that did the trick! thank you so much for your help with this! I really appreciate it!