MIS Systems Thread, Using = blank in an Assessment Template in Technical; Hi, Is it possible to use the following formula in SIMS.net if [Column/Constant] = blank , then use [Column/Constant]? ifthenelse.png...
1. ## 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]?

ifthenelse.png

2. 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.

3. 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?

4. 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?

5. 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

6. 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?

7. 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.

8. 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

9. 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

10. 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..

11. Yeah, the Ns don't matter so much.

Now I'm stumped.

sorry.

12. ## Thanks to tombry from:

bastonc (1st July 2013)

13. No worries tombry.

14. 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

15. Hi tmcd35,

Thanks for your post. I have tried it and still have the same problem.

16. 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]

SHARE:
Page 1 of 2 12 Last