How to display the result of the sum where only the fields are filled in?
Rizky.Tuasikal
Contributor
1. I have several fields, namely:
Moa Amount Infra 1 & MoA Amount Non-Infra 1
Moa Amount Infra 2 & MoA Amount Non-Infra 2
Moa Amount Infra 3 & MoA Amount Non-Infra 3
where those fields will be calculated using the sum.
the result will be recorded in this fields
Moa Amount Total 1
Moa Amount Total 2
Moa Amount Total 3
2. Above is an example of a query to get the sum for the Moa Amount Total field using JMWE
3. The picture above is the result of the sum
The question is,
how do you make the Moa Amount Total 2 & 3 fields does not count?
(does not display "0" results in its field)
