Object Report With Conditionals

[TCTech]

I am attempting to create a conditional response within an object report based upon the following  syntax:

~([Students.U_Students_Extension]HLS_NT_YN;if.fieldvalue.Yes.then=~([Students.U_Students_Extension]HLS_NT_YS))

I would like the report to render the value of [Students.U_Students_Extension]HLS_NT_YS when the value of 

[Students.U_Students_Extension]HLS_NT_YN evaluates to "Yes", and render nothing (blank) when the value of [Students.U_Students_Extension]HLS_NT_YN evaluates to "No".

(Please note: similar but different field names ,"YN" vs. "YS")

Is this possible?

Also, what is the difference between the conditional statements:

^(field;if.fieldvalue.XX.then=result)

and]

^(field;if.fieldvalue#XX.then=result)

[TCTech]

It should also be noted that the statement above currently renders "No" when the value of [Students.U_Students_Extension]HLS_NT_YN evaluates to "No", and 

nothing (blank) when the value of [Students.U_Students_Extension]HLS_NT_YN evaluates to "Yes".

[jbloom1]

I am working on something similar to this. Were you able to get this working?

[jbloom1]

I actually got mine working. This document helped me get the right conditions set up. How-To: PowerSchool SIS - IF THEN and DECODE - PowerSchool Community

I had one field that was populated from a form with 2 possible answers. This is what I ended up with: 

^([Students.U_Students_extension]CA_Q1;if.fieldvalue.N.then=X;if.fieldvalue.Y.then= ) 

If CA_Q1 value is N it would populate an X (to act as a checkbox on a printed form) if the value was Y it would show up blank.

I am thinking with yours you will need to have another IF letting it know what to do when the answer is YN so something like this:

^([Students.U_Students_Extension]HLS_NT_YN;if.fieldvalue.Yes.then=^([Students.U_Students_Extension]HLS_NT_YS);if.fieldvalue.No.then= )

I am not sure if you need to replace the ^ with ~ like in your conditionals before but I needed to have ^ to work for me.

^(field;if.fieldvalue.XX.then=result) ----  The fieldvalue equals a variable (XX)

^(field;if.fieldvalue#XX.then=result) ---- The fieldvalue does not equal a variable (XX)

[wilhelzm]

I'd like to do something similar.

What I would like to do is have the object report check the PSCORE_LEGAL_FIRST_NAME and PSCORE_LEGAL_LAST_NAME fields. If those fields return blank, then I would like the report to use the First_Name and Last_Name fields instead.

[mbuonato]

Try this. Basically if the legal first name is blank it will use the first name 

^(decode;^(StudentCoreFields.PSCORE_LEGAL_FIRST_NAME);;^(first_name);^(StudentCoreFields.PSCORE_LEGAL_FIRST_NAME))