Skip to main content

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!

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))

 

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

Reply


Terms & Conditions