-
I am attaching a form which should demonstrate what you are trying to do.
-
I am attaching a pic of what I have done so far in this repeating table....I have set TotalRow as a text box with the function in it and am getting the error I mentioned above. When I make it a Calculating field, it adds a field to the bottom of the canvas, outside of it, and marks the "HourlyRetroWage" Group with control ...
-
So my tree is:
HourlyRetroWages
HourlyPosition
RegRateDiff
NumberRegHours
OTRateDiff
NumberOTHours
TotalRow (I placed my function to total the row here)
TotalHourlyRetro (This is where the Sum(TotalRow) function is) (I set this outside of the tree and made a footer for the ...
-
I am kinda lazy. I'd use two expression boxes for this - one that shows all of the text up to the $ sign, then another that is just the Dev_Cost field, formatted as currency & set to display two decimal places.
-
Oh...I have learned something new....I did not know I could do that...thank you again...I will let you know if I can get it to work for me.
-
By not showing you not putting it on your form canvas. The part you showing. You can have fields just left in the tree on the right that perform functions or are helper fields. Sorry for it being confusing.
-
How do you not show a field? Apologies for not knowing too much yet....
-
I mean you don't need to show the field in the repeating table. Because you said you didn't want row totals. You only wanted a grand total.
-
Thank you for responding! What do you mean "Don't put on canvas?"
-
Put a field in your repeating group label something like RowTotal. Then put your function on that field. Now you will get a total for each row. (Don't put on canvas) Then create a field outside of the repeating group called Total. Place that field in the footer of the repeating table and put this function Sum(RowTotal)