Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Quick Syntax check,
Can anyone see my error?? its on the final line some where
count({$<ArbitrationInput.Group.rOOk = {"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rRMk"},
ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rQo"},
ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rQMk"},
ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk <" only( {$ < [/rec/Parameter] = {'rFf'}>} [/rec/parameter/curval]) >} ArbitrationInput.Group.rOOk)
thanks all
I think the last double quote must be at the end and not before only(...)
=count(
{<
ArbitrationInput.Group.rOOk = {"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rRMk"},
ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rQo"},
ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk > ArbitrationInput.Group.rQMk"},
ArbitrationInput.Group.rOOk ={"=ArbitrationInput.Group.rOOk < only({<[/rec/Parameter] = {'rFf'}>}[[/rec/parameter/curval])"}
>} ArbitrationInput.Group.rOOk)
Hi
First of all, these expressions look like line-by-line comparisons. A set expression is evaluated once for the whole chart and not line by line, so that logic will not work.
Secondly (this is only relevant if they are NOT line by line comparisons), the multiple conditions for the ArbitrationInput.Group.rOOk field will be the intersection of the possible values, rather than the union - I am not sure what you want here.
Finally, the last clause makes no sense to me. Does the Only expression apply to the whole data set, or to some dimension? If the latter, see point 1.Otherwise you could define a vriable like:
Set vExpr = =only({$<[/rec/Parameter] = {'rFf'}>} [/rec/parameter/curval]);
(The double = are not a typo).
And use the variable in the set expression. This is also evaluated once for the chart and not once per line.
HTH
Jonathan