Please either Logon or create a New Account.
DAT code for object report - HELP
I just can't figure this out.  Have spent hours trying.  On an object report for our High School report card I am trying to use a DAT to pull a percentage if there is a stored percent and nothing if there is not a stored grade for that period.  

This is what I am using -
^(stored.by.course.period;3(A); S1;percent;if.#blank.then.stored.by.course.period; 3(A);S1;percent.blank)^(stored.by.course.period;3-4(A);S1; percent;if.#blank.then.stored.by.course.period;3-4(A);S1; percent.blank)

If there is nothing stored it pulls a zero and I am wanting a blank.  Any ideas?
Thanks.

Bev Lauby
Tags:
Comments
1 Response to "DAT code for object report - HELP"

   
I think that if you put a semicolon-space-parenthesis rather than the DAT code it will work. 

^(stored.by.course.period;3(A);S1;percent;if.#blank.then.stored.by.course.period;3(A);S1; )^(stored.by.course.period;3-4(A);S1;percent;if.#blank.then.stored.by.course.period;3-4(A);S1; )
Would you like to comment? Join The PowerSchool Community for a free account, or login if you are already a member.