TM1 Newbie

[Richard123]

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

[lotsaram]

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'];

[Richard123]

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