Help

REPT Formula issue Referencing results from another formula

Topic Labels: Formulas
Solved
Jump to Solution
800 2
cancel
Showing results for 
Search instead for 
Did you mean: 
dcalderon
4 - Data Explorer
4 - Data Explorer

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!
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

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
4 - Data Explorer
4 - Data Explorer

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