sum of the colon

phondaj · 2009-02-28

hi everyone,

I want to collect (to get sum) of one of colon but only if the statement is right
No. No2
3

1
6
9

1
10----1
so I want to get sum os the colum no. if No2 = 1, did navision hav any function like "where" on mysql

mohana_cse06 · 2009-02-28

take a var sum and initialize to 0

if no.2 = 1 then
sum := sum + No;

write this code wre u want to sum them.

satraja2004 · 2009-03-02

Hi,

U can use flow field for that, and give the condition on which you need to sum

Comments