Question:
Hi All,
I need someone to help me with the following.
I have defined a field 'Overdue' = Contracted hours - Actual hours. Right now it is bringing all values including zeroes and negative values. I want the report to show strictly values only if Actual hours are more than contracted hours. How can I make this possible at the query definition level? A quick help will be much appreciated.
Thanks in advance.
Answer:
2.1C:
Build a 'Condition' where 'Overdue' is between 0.0000001 and 999999999.
However, if you do this your 'Results' row(s) will include the values for rows that are not displayed. If this is not satisfactory, you can supress all results in the workbook, and then use Excel for the totalling.
Answer:
Sorry, I was thinking of the 'Exception' definition screen on my previous post. Here's a corrected post, using the 'Condition' definition logic:
2.1C:
Build a 'Condition' where 'Overdue' is greater than 0, for all characteristics in the drilldown.
The condition definition button is in the middle of the toolbar of the query definition screen.
However, if you do this your 'Results' row(s) will include the values for rows that are not displayed. If this is not satisfactory, you can supress all results in the workbook, and then use Excel for the totalling.
Answer:
Why don't you just use a formula in the BEx???
cheers,
El Belgio