


I have a total sum field that takes values from two different subforms. One subform has an initial count of 0.
If users want, they can "add" that subform into view.
So, I imagine I need two if conditions for my calculations. One with only 1 subform and one with 2 subforms.
under calculate event
formCalc
I tried this:
if (RepeatWrap.instanceManager.count == 0 ) then
$.rawValue = Sum(Table1.Row[*].Cell8);
else
$.rawValue = Sum(Table1.Row[*].Cell8)+Sum(RepeatWrap[*].Table1.Row[*].Cell8);
endif
RepeatWrap is the second subform.
If course this is not working..
Is it my syntax or my logic? Most likely both... T_T
Many thanks in advance
Views
Replies
Sign in to like this content
Total Likes
I've solved my own syntax errors.
the solution for a Logic IF statement in formCalc under Calculate event:
if (RepeatWrap.instanceManager.count eq "0")
then
$.rawValue=sum(Table1.Row[*].Cell8)
else
$.rawValue=sum(Table1.Row[*].Cell8+(RepeatWrap[*].Table1.Row[*].Cell8)
end if
Hope this serves as a good reference.
Views
Replies
Sign in to like this content
Total Likes
I've solved my own syntax errors.
the solution for a Logic IF statement in formCalc under Calculate event:
if (RepeatWrap.instanceManager.count eq "0")
then
$.rawValue=sum(Table1.Row[*].Cell8)
else
$.rawValue=sum(Table1.Row[*].Cell8+(RepeatWrap[*].Table1.Row[*].Cell8)
end if
Hope this serves as a good reference.
Views
Replies
Sign in to like this content
Total Likes