July 8, 2015 at 1:09 pm
I have a report looking at number of units on which type of contract. If the customer only has one type of contract the numbers and indicators for the other contract type should display an empty or blank data. The lights are just indicators driven by the formula that returns the percentage aside of it.
In my sample where the CFPM units are 0 highlighted in yellow, the cells to the right that are also yellow. I want nothing displayed or the appearance of nothing. The same would apply when the SM units are 0 highlighted in blue. the cells to the right in blue would display nothing.
Thanks for helping,
July 8, 2015 at 1:16 pm
grayner 26961 (7/8/2015)
I have a report looking at number of units on which type of contract. If the customer only has one type of contract the numbers and indicators for the other contract type should display an empty or blank data. The lights are just indicators driven by the formula that returns the percentage aside of it.In my sample where the CFPM units are 0 highlighted in yellow, the cells to the right that are also yellow. I want nothing displayed or the appearance of nothing. The same would apply when the SM units are 0 highlighted in blue. the cells to the right in blue would display nothing.
Thanks for helping,
Use an expression to replace your count in the report.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 9, 2015 at 6:53 am
Alvin,
Thanks I put the unit count lookup clause in the iif statement, not just referencing the count.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply