Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

REPT Formula issue Referencing results from another formula

Topic Labels: Formulas
Solved
Jump to Solution
986 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!