jschill2628
Programmer
I have a cross tab without a time range, by severity, entity and by claim count. What I want to do is only show those Claims that fit the following criteria:
({CHICLAIM.REPORT_DT} in DateTime (2013, 07, 01, 00, 00, 00) to {@Run Date})
@RunDate= previous month
If ({CHICLAIM.SPECIAL9}) = "04" then "Severe Harm"
if ({CHICLAIM.SPECIAL9}) = "05" then "Death"
So I only want to see the Severe Harm and Death for FY14. However I also want to show those Entities that do not have claims that are Severe Harm or Death.
Is there any way to do this? If there is, is there also a way to show that an entity without Severe Harm or Death that the claim count is equal to zero?
Thanks in advance!
({CHICLAIM.REPORT_DT} in DateTime (2013, 07, 01, 00, 00, 00) to {@Run Date})
@RunDate= previous month
If ({CHICLAIM.SPECIAL9}) = "04" then "Severe Harm"
if ({CHICLAIM.SPECIAL9}) = "05" then "Death"
So I only want to see the Severe Harm and Death for FY14. However I also want to show those Entities that do not have claims that are Severe Harm or Death.
Is there any way to do this? If there is, is there also a way to show that an entity without Severe Harm or Death that the claim count is equal to zero?
Thanks in advance!