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
Here is a solution that produces the following results....
Where cell labelled 'A*B*C' has a FormCalc calculate event as depicted by row, below
// form1.page1.subform1.table.row.sum::calculate - (FormCalc, client)
var sum = row.a + row.b + row.c
if (sum == 0) then
Max(row.a,1) * Max(row.b,1) * Max(row.c,1)
Thank you, it works like a charm.