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