I am trying to use Spotfire 7.11 Repeat function like Repeat('Hello', sum[columnName])) but it is giving error. It works fine if I type Repeat('Helo',5)

[Manju Goyal 2]

It seems Repeat function is not able to take other calculated values. Is that true.

 

I tried fixing this by writing instead

sum([ColumnName]) then Repeat('Hello',[Value]) but that wouldnt work either.

 

Any help would be greatly appreciated.

[Kirsten Smith (she/her)]

Repeat() works on string values. Try something like:

 

Repeat(String(Sum([Column])),3)

[Kirsten Smith (she/her)]

I see I misread your initial question. The Sum() function seems to create a Real, even on an Integer column. Try this:

 

Repeat("Hello", Integer(Sum([Column])))

[Manju Goyal 2]

This worked like a charm. Thanks!