Modify formula to work in text box

[samuel_brierley]

Hi all, i have the following formula that I use in a table that has time as the dimension.

what I want to do is modify the formula in such a way that it counts the number of ones over the time period and put this into a text box.

thanks in advance

if( SwitchOnOffVariables.Group.onOffState = 'RUNNING' and
ArbitrationInput.Group.rQo = 250 and
below(ArbitrationInput.Group.rQo,1,1) > 250 and
below(ArbitrationInput.Group.rQo,2,1) > 250, 1,'')

[alexandros17 · Accepted solution]

Try with

Sum(Aggr(

if( SwitchOnOffVariables.Group.onOffState = 'RUNNING' and
ArbitrationInput.Group.rQo = 250 and
below(ArbitrationInput.Group.rQo,1,1) > 250 and
below(ArbitrationInput.Group.rQo,2,1) > 250, 1,'')

,Time))

let me know

[richard_chilvers]

Hi

I'm not entirely clear what you need to achieve, but in yout text object you can have any string which might be straight text and fields or variables. The ampersand  (&) joins the strings together.

So it might be something like:

='This is a line of text which includes the value of the field called STRING_FIELD' & STRING_FIELD

The 'field' could also be a variable.

Hope that helps.

[samuel_brierley]

Thats it thank you very much, a nice little learner there too