Page 1 of 1

RULE LINE ERROR [] = S:

Posted: Thu Oct 30, 2014 10:55 am
by bogdan
Hello!
I have a dimension in which both text and numeric elements. I need for all text to execute the rule which will be the first.

Code: Select all

[] = S: IF(!Version @<> 'New', CONTINUE, STET);
But then writes the error in the trace on the consolidated elements "RULE LINE ERROR"
Tell me how to solve the problem? Thank you

Re: RULE LINE ERROR [] = S:

Posted: Thu Oct 30, 2014 12:06 pm
by jim wood
You might want to put an level test in there. Then it wil not try to apply this to consolidated levels. Hint: ElLev.

Re: RULE LINE ERROR [] = S:

Posted: Thu Oct 30, 2014 6:18 pm
by David Usherwood
I was thinking of DTYPE - one of the lesser-used functions, but seems to fit the bill here.

Re: RULE LINE ERROR [] = S:

Posted: Thu Oct 30, 2014 6:50 pm
by Willi
DTYPE is my first guess as well

Re: RULE LINE ERROR [] = S:

Posted: Thu Oct 30, 2014 8:10 pm
by jim wood
I was thinking of DType as well at first, but as this is a string rule, surely it will only apply to string elements at the N: level? S: rules however also apply to consolidated elements as well, hence my reason for ElLev. Thoughts??

Re: RULE LINE ERROR [] = S:

Posted: Thu Oct 30, 2014 8:11 pm
by jim wood
Possibly combine the 2???

Re: RULE LINE ERROR [] = S:

Posted: Fri Oct 31, 2014 12:14 pm
by Duncan P
Try

Code: Select all

[] = S: IF('New' @<> !Version, CONTINUE, STET);