I'd like to make a simple calulation i LC where one or more of the cells contains no data. The following works well: Numericfield1*Numericfield2*Numericfield3 and so on, as long as all cells contains data, with one or more empty cells it all ends out with = 0. Is there any possibility to calculate all cells also them with no data, or set cells with no data to 1, but invisible for the user?
Thanks in advance
Views
Replies
Total Likes
Here is a solution that produces the following results....
Where cell labelled 'A*B*C' has a FormCalc calculate event as depicted by row[0], below
// form1.page1.subform1.table.row[0].sum::calculate - (FormCalc, client)
var sum = row[0].a + row[0].b + row[0].c
if (sum == 0) then
0
else
Max(row[0].a,1) * Max(row[0].b,1) * Max(row[0].c,1)
endif
Steve
Views
Replies
Total Likes
Thank you, it works like a charm.
-Zjur
Views
Replies
Total Likes