I have a data item in my report that counts the # of times target status was edited to the type "shortlist". What I want to see is the line items the count is 0, not the ones that have hit this edit.
When I run the report, it will not show 0 count lines, is there a way I can flip this? I tried the expression that of:
case when ([Target Status] < '1'))
and
([PRESENTATION VIEW - JOB ANALYSIS].[JOB].[status] = 'signed agreement')
then ([PRESENTATION VIEW - JOB ANALYSIS].[JOB].[jobPostingID]) else '0' end
However, this does not work as the count only shows values 1 and higher, not 0.
not really sure what you are trying to do but try...
case when ([Target Status] < 1))