Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,'')
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
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
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.
Thats it thank you very much, a nice little learner there too