Joined: 23 May 2011
Online Status: Offline
Posts: 16
Topic: IF statement - multiple checks Posted: 06 Feb 2012 at 11:26am
I can not get the if statement correct, get syntax correct enough that I do not get errors but it is not given me the results I should be. I know there is data that should be counted but it is not. If the CPTCategory is not one that is listed I want to count it.
Thanks for any help!
if IsNull({spOIA_DailyExamFlashSummary.CPTCategory}) OR {spOIA_DailyExamFlashSummary.CPTCategory} <> "CT" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Bone Density" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Fluoroscopy" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Mammography" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "MRI" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "PET" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Special Procedures" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Plain Film/ Xray/ CR" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Ultrasound" AND {spOIA_DailyExamFlashSummary.CPTCatID} <> 6 Then {spOIA_DailyExamFlashSummary.ExamCount} Else 0
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 06 Feb 2012 at 12:02pm
Depends on what your conditions are supposed to be.
I can't quite tell on the statement.
Proabaly this though...
if (IsNull({spOIA_DailyExamFlashSummary.CPTCategory}) OR NOT({spOIA_DailyExamFlashSummary.CPTCategory} in ["CT","Bone Density", "Fluoroscopy","Mammography","MRI","PET","Special Procedures","Plain Film/ Xray/ CR","Ultrasound"]))
AND {spOIA_DailyExamFlashSummary.CPTCatID} <> 6 Then {spOIA_DailyExamFlashSummary.ExamCount} Else 0
Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Posted: 06 Feb 2012 at 12:40pm
if IsNull({spOIA_DailyExamFlashSummary.CPTCategory}) OR ( {spOIA_DailyExamFlashSummary.CPTCategory} <> "CT" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Bone Density" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Fluoroscopy" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Mammography" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "MRI" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "PET" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Special Procedures" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Plain Film/ Xray/ CR" AND {spOIA_DailyExamFlashSummary.CPTCategory} <> "Ultrasound" AND {spOIA_DailyExamFlashSummary.CPTCatID} <> 6 ) Then {spOIA_DailyExamFlashSummary.ExamCount} Else 0
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum