How to calculate total?
Posted on 2001-08-02
I have created a form and on that form, it contains 3 product names which will varies depend on what the user enter e.g field 1 contains "Trend",field 2 contains
"Microsoft Office" and field 3 contains "Symantec".
I want to compute the above as the licenses for each product so if there are a lot of forms entered in the view, under one of the column, it will display the total licenses for each product.
I try with this formula but there's error.
temp := 0;
@If(@Contains(product | product_1 | product_2;"Officescan");temp+1;1)
How do I achieve what I want?