TM1 Forum

Posted: **Fri Apr 23, 2010 9:45 am**

Hello,

I am completely new to TM1 (and this forum) and have a query that will no doubt only take someone a couple of seconds to answer.
I the following rule set up in TM1:
['CVA - Count']=N:IF(['Key Stage 2 to 4 contextual value added measure']<>0,1,0);

However I also want this rule to work for Key stage 4 to 5 contextual value added measure so i am thinking that an or (%) expression needs to be used but I dont know how or where to do that.

Could someone please advise if possible

Posted: **Fri Apr 23, 2010 12:00 pm**

The answer depends. Do you want to count "Key stage 4 to 5 contextual value added measure" against "CVA Count" as well or do you want a separate count?

Assuming you need only a single count:

Code: Select all

['CVA - Count'] = N:
IF( ['Key Stage 2 to 4 contextual value added measure']<>0 % ['Key Stage 4 to 5 contextual value added measure']<>0,
  1,
  0
);

Dont forget that you would then also want to feed CVA Count from Key stage 4 to 5 contextual value added measure and not just from Key stage 2 to 4 contextual value added measure.

EG.

Code: Select all

FEEDERS;
 ['Key Stage 2 to 4 contextual value added measure'] => ['CVA - Count'];
 ['Key Stage 4 to 5 contextual value added measure'] => ['CVA - Count'];

Posted: **Fri Apr 23, 2010 2:26 pm**

I had already added it into the feeder section however I couldnt work out where to put the OR expression.

That makes perfect sense and seems to work.

Thank you ever so much for your resonse it is greatly appreciated

Regards

TM1 Forum

TM1 Newbie

TM1 Newbie

Re: TM1 Newbie

Re: TM1 Newbie