Data Analysis Views - Do not display Zeros

D

Dots

How can I get my data analysis views to display only rows with greater than
zero. For instance, I am displaying actual hours against a project task and
only want to see those line items greater than zero hours.

Thanks.
 
J

Jonathan Sofer

One way you could do this is to display a calculated field rather than the
[Actual Hours]. The calculation would replace 0 with Null, thus not
displaying it in the report.

IIF([Measures].[Actual Work]=0,Null,[Measures].[Actual Work])

This only works well if you are displaying one field only.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Analysis-Truncating Hours to display Zero decimal places 3
Data Analysis views from the 3 Timesheet cubes using Customized Fi 2
Data Analysis not showing correct Actual Work 3
Data Analysis Views Dashboard 0
Total daily actual work 3
Olap data views 3
Creating Data Analysis Views 1
Resource Assignments not showing in Data Analysis 1

Top