count function that doesnt factor in hidden sections

[pinkpoppy]

I have a formula that is counting a field, but it is also factoring the 'details' section when I insert a field.
How do I stop the formula from not factoring in the details section and only count and display one the field I need?

 

[hilfy]

The answer depends on what you're counting.

Have you tried a distinct count? That will automatically only count each value the field once and ignore any duplicates.

I think that's probably what you're looking for, but if that's not, you have a couple of options depending on the report requirements and your data:

1. Use the Select Expert to filter out the data that you're not displaying. This might automatically take the duplicates out of the report so you only count them once.

2. If you have to have the data in the report but you're using a formula to suppress sections, you could create a formula like this:

if <section suppress formula> then 0 else 1

You would then do a Sum on the formula to get a count of your records.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com