Help

Help with Formula using REPT

Topic Labels: Formulas
671 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Daniel_Hamer
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello.

I have two tables. Hardware and Ratings. Hardware is linked to Ratings and rolls up different ratings for hardware records.

I have a roll up field in the Hardware table called ‘Average Rating Back’ which rolls up all the ratings (from the Ratings table) per hardware record to create an average. The formula I’m using here is:

IF(ISERROR(AVERAGE(values))=0, AVERAGE(values), BLANK() )

I have a formula field as below in the Hardware table which converts the roll up fields integer and turns it into stars (essentially an average rating).

IF({Average Rating Back}="",“This hardware hasn’t been reviewed yet”,REPT(“ :star: ”, {Average Rating Back}))

If I don’t have an integer in the roll up field then the text will appear as per the IF statement. If I do have an integer then I use REPT to show a star per integer i.e. 2 = :star: :star: .

This was all working fine until I just received an #ERROR! after the roll up field rolled up a ‘5’ and a 4’ rating for a hardware record.

Do you know where I’m going wrong?

Thanks!
Dan

0 Replies 0