Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using the following as an expression and it is working
Sum({<TERM_CODE_EFF={'2012-13'},REG_STATUS={'RE','RP','RS','WU'},StudyYearCommencementDate={'>01/09/2012''<01/08/2013'},[No Attendance]={'X'}>}Today()-StudyYearCommencementDate)/17
I want to add an IF to the sum statement and have tried a number of different methods but I am not getting nowhere so any help is appreciated.
My IF statement on its own is as follows;
If (LEVEL='PGR',Sum(Today()-StudyYearCommencementDate/41),Sum(Today()-StudyYearCommencementDate/17))
Does this do what you need?
Sum({<TERM_CODE_EFF={'2012-13'},REG_STATUS={'RE','RP','RS','WU'},StudyYearCommencementDate={'>01/09/2012''<01/08/2013'},[No Attendance]={'X'}>}Today()-StudyYearCommencementDate)/if(LEVEL='PGR',41,17)
Does this do what you need?
Sum({<TERM_CODE_EFF={'2012-13'},REG_STATUS={'RE','RP','RS','WU'},StudyYearCommencementDate={'>01/09/2012''<01/08/2013'},[No Attendance]={'X'}>}Today()-StudyYearCommencementDate)/if(LEVEL='PGR',41,17)
Perfectly thank you