Count other than zero value
I have created a report with field "Amount" consists of records like shown below.
I used count function in report footer text box
result was 7
I want to count records which are <>0
Is there any function like "CountIf" which is available in Excel
Any help on this