Count separately positive and negative numbers
There is a table where the results of the work of each day are displayed, a formula is needed to separately calculate the total amount of the results of the days, not the number of days, but the result of all days when there was a positive amount.
For example, in 7 days there were 5 positive results and 2 negative ones. Ineed the amount of income received for those 5 days when there was a profit, not including the result of 2 negative days.
Regards Mamuka
2 replies
-
If your the amount is held in a field called amount then somewhere in your table include a formula field with max(amount,0) for the positive days and (if you want) min(amount,0) for the negative days. You can then sum the postive days as required.
Regards John
-
Tnanx John, works perfectly
Mamuka
Content aside
- 3 yrs agoLast active
- 2Replies
- 254Views