[sims] If Function in individual report in WORD from SIMS

[iamwaitingforgodot]

Hello all,

First time poster - long time reader. My background is in Visual Basic and Excel but I am trying for the first time to create an individual report in Word from SIMS with conditional formatting but without VB and am struggling to get the syntax right. Any help appreciated!

 

Essentially there are six aspects on a marksheet that link to curriculum objectives. To save staff workload, they enter an N when an objective has not been met and leave it blank if it has. The report will then list all curriculum objectives and where there is an N it will print the text Not Yet Met. Ideally, it will also then print Met if the cell is blank or contains any other value.

 

I have tried various ways - see below - but cannot get it to work. I would be so grateful if anyone can correct my syntax.

 

For the simple If I have tried - { if <> = "N" "Not Yet Met" } - with spaces as they appear here.

 

I have also tried adding field brackets around the aspect to see if that helped... { if {<>} = "N" "Not Yet Met" }

 

And thinking it might be missing an 'else' I've even tried { if {<>} = "N" "Not Yet Met" "Met" }

 

As well as { if <> = "N" "Not Yet Met" "Met" }

 

Can anyone put me out of my misery? Each version just repeats my code back.

Thanks in advance!

[Bill8]

I've something similar with some of my marksheets.

Try this:

Assign the Grade "N" with the value 1 in the Grade Set being used with the Sub-Objective column aspect.

Assign the Grade "Y" with the Description "Met", and "N" with the Description "Not Yet Met", in the Grade Set being used with the Main-Objective column aspect

 

In the Marksheet include the students 'Reading age' column.

Use these formula columns:

Data Entry Columns

1. Sub-Objectives

 

Data Review using Formula columns

1. SUM

Sub-Objective columns and Reading Age column

2. DIFFERENCE

the SUM column and the Reading Age column

 

Data Entry using Formula: Main-Objective

1. IF THEN ELSE

IF the DIFFERENCE column = 0

THEN Y

ELSE N

 

In the Report Template Word document use:

Add-ins > Result Description

instead of

Add-ins > Result

 

I hope this all makes sense?

[iamwaitingforgodot]

That's a really ingenious solution. The use of reading ages is a curveball but I see that as it will always be greater than zero it provides a great reliable way to trigger the right condition. Excellent - thank-you!