I have a statement, in which, against four quarters, their target vs. achievement figures along with total target & achivement are appearing like as below
Quarter-1 Quarter-2 Quarter-3 Quarter-4 Total
Tgt. Ach Tgt. Ach Tgt. Ach Tgt. Ach Tgt. Ach
15 10 12 0 22 0 18 14
Now, I want to sum the computed target of all four quarters in Total column where corresponding achievement is greater than 0. Thus means, from the above example, I want to sum only target of Quarter-1 and Quarter-4 only.
I have tried with the sum with if command, but it does not work if achievement is 0 and returns "FALSE".