Skip to main content
Solved

REPT Formula issue Referencing results from another formula

  • December 4, 2023
  • 2 replies
  • 25 views
D
Forum|alt.badge.img+1

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!

Best answer by Sho

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

 

2 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • December 5, 2023

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

 

D
Forum|alt.badge.img+1
  • dcalderon
  • Author
  • New Participant
  • December 5, 2023

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

Terms & ConditionsAccessibility statement