# Using = blank in an Assessment Template

Show 25 post(s) from this thread on one page
Page 1 of 2 12 Last
• 28th June 2013, 02:08 PM
bastonc
Using = blank in an Assessment Template
Hi,

Is it possible to use the following formula in SIMS.net

if [Column/Constant] = blank, then use [Column/Constant]?

Attachment 19066
• 29th June 2013, 12:43 PM
vikpaw
No i don't think so, it might depend on the column type. I'm sure there are tricks to overcome this, like adding something to all columns like 0 if it's numeric, then testing for 0.
• 1st July 2013, 12:03 PM
bastonc
Hi vikpaw,

I am now trying;

if points column A is >0, then use whats in grade column B otherwise use whats in grade column C

I'm still not getting anywhere.

Any ideas?
• 1st July 2013, 12:37 PM
tombry
I know when I made my Eng Bacc aspects it was an absolute pain, as it seems that SIMS counts a blank as both >0 and <0 (or 1).

what are you trying to get your marksheet to do?
• 1st July 2013, 12:46 PM
bastonc
Hi tombry,

I’m trying to have it so that if a pupil has a KS2 level then that is used to calculated their end of year/end of KS target, if they haven't got a KS2 level (many of our Service Pupils don’t) then use their subject baseline level.

So,

If [KS2] =”” then [Baseline] otherwise [KS2]

I have also tried,

If [KS2 pointscore] <= 0 then [Baseline] otherwise [KS2]

Hope that makes sense
• 1st July 2013, 12:52 PM
tombry
well, I think you could probably do it like I had to do my EBacc then.

set a column to grade tally the KS2 aspect, tallying all grades, then set a column to count if that tally column = 1, make that Y/N

then your if else statement is if your Y/N field = Y, use KS2, else Baseline

make sense?
• 1st July 2013, 01:07 PM
bastonc
thanks tombry,

I'm getting there with it.

I now have a column with 1.00's and blanks.

I can't find 'count' from the formula type column, am I missing something?

Also tried

if [tally column] =1.00 use [KS2] else [Baseline] but nothing.
• 1st July 2013, 01:09 PM
tombry
sorry, didn't mean "count" - it's a simple If Then statement, if tally column = 1, then Y, else N

and I don't know why it works one way and not the other, neither did my LA support team
• 1st July 2013, 01:21 PM
bastonc
Ok, so I now have:

a column that puts a 1.00 where there are [KS2 level]

a column that puts a Y if there is a 1.00

a column thats equals the Y column (because it wouldn't let me if a if column)

and the actual calculation column

if Y then [KS2], else [Baseline]

Unfortunately I'm still not getting any baseline appearing for pupils with no KS2

I have noticed aswell that there are no N's appeaing in the rows with no 1.00's
• 1st July 2013, 01:33 PM
number34
This probably not much help but...
In similar situations I have given up trying to use a formula as there is just not the functionality in SIMS. I have all the relevant aspects in a template, make up mark sheets as required and then used the filters at the top of the columns to search for blanks. I then filter the other columns and just copy from column to column as required..
• 1st July 2013, 01:53 PM
tombry
Yeah, the Ns don't matter so much.

Now I'm stumped.

sorry.
• 1st July 2013, 02:00 PM
bastonc
No worries tombry.

• 1st July 2013, 02:05 PM
tmcd35
Quote:

Originally Posted by bastonc
Ok, so I now have:

a column that puts a 1.00 where there are [KS2 level]

a column that puts a Y if there is a 1.00

a column thats equals the Y column (because it wouldn't let me if a if column)

and the actual calculation column

if Y then [KS2], else [Baseline]

Unfortunately I'm still not getting any baseline appearing for pupils with no KS2

I have noticed aswell that there are no N's appeaing in the rows with no 1.00's

An idea...

Column 3 = If "column 1 < "value for lowest possible score" then "column 2" else "column 1"

A "1C" is worth 7 points so IF "Column 1" < 7 THEN "Column 2" else "Column 1"

SIMS should see the underlying value of th grades in column1 so there's no need to go through extra steps converting grades to values to make the comparison
• 1st July 2013, 02:08 PM
bastonc
Hi tmcd35,

Thanks for your post. I have tried it and still have the same problem.
• 1st July 2013, 02:24 PM
bastonc
CRACKED IT!!

Changed the if statement column from Data Review with Formula to Data Entry with formula

Then went through the original process;

if [KS2] = "" then [Baseline], else [KS2]

:cool:
Show 25 post(s) from this thread on one page
Page 1 of 2 12 Last