Quick formula check

[samuel_brierley]

Hi all,

thanks for any help on this,

the below is a snippet of a formula that isnt evaluating.

the issue seems to be the only segment because if i replace it with its value (1200) it works fine.

any suggestions?

=

avg(IF(RampDataFilteringOutput.Loopp1.sORLoopK > 35 and RampDataFilteringOutput.Loopp2.sORLoopK > 35 and
ArbitrationInput.Group.rOOk < only( {$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval])
,1,2))

[terezagr]

hi

I think it does not know what to evaluate - try to add a brackets as follow:(RampDataFilteringOutput.Loopp1.sORLoopK > 35 and RampDataFilteringOutput.Loopp2.sORLoopK > 35 and  ArbitrationInput.Group.rOOk)

avg(IF((RampDataFilteringOutput.Loopp1.sORLoopK > 35 and RampDataFilteringOutput.Loopp2.sORLoopK > 35 and
ArbitrationInput.Group.rOOk) < only( {$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval])
,1,2))

[samuel_brierley]

Hi, thanks for the quick response, I dont think the brackets are the issue as the value works and ive just tried with creating a variable in the script and that worked too.

[terezagr]

have you tried put {'Live'} into a single quotes?

[samuel_brierley]

Again yup ive tried that, and ive also put the only statement in a text box to ensure that its actualy returning a number and it is. really quite annoying

[terezagr]

Could you please explain what you are trying to do with your formula?

[stigchel · Accepted solution]

If the Only statement is returning a correct value in a seperate text box, the easy solution would be to create a variable with the only expression like (e.g. vParameter)

= only( {$< [/rec/parameter] = {'rOff'},[/#text] = {'CommonParameters'},[Config] = {Live}>}[/rec/parameter/curval])

DO include the = sign, so it will evaluate at the variable level, in your expression replace the Only(..... with

$(vParameter)

[samuel_brierley]

thanks this is the way Ive done it