Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi,
i have a tablebox with 4 fields by 4 rows.
i want to sum the result of 2 specific fields F1 & F2 together.
the script (example) is like this:
LOAD * INLINE [
F1, F2, F3, F4
1, 5, A, X
2, 6, B, X
3, 7, C, X
4, 8, D, X
];
the total sum will be displayed in a different textbox.
how can it be done?
moti
Sum(F1) + Sum(F2)
Where are you confused?
thanks, Rebecca for your reply.
i forgot to add that F1,F2 is actualy an example.
my need it to have a summery of a group of fields, thus F1,F2....Fn.
i have created a group (via document properties) and add all the fields i need (52)
and tried to sum(GroupName), or sum $(GroupName) or sum(<GroupName>)
but no luck.
can you assist?
moti
Try this expression: sum(rangesum(F1,F2,...,Fn))
thanks,
is there a way to do with a loop, like:
for i=1 to 52
sum w(i)
next
Can you please upload your sample application.