Add child total to a field on parent (1 reply)
I tried the Sum function but because my field was not correctly named in the parameter, the formula gave an error at preview stage even though the check button validated ok. I have corrected the field name. Everything now works ok.
I have a list of child documents each with a monetary value against them. I can use the aggregate transform to summarise the amounts and create an extra child. How would I go about getting this summary amount and putting that amount at parent level?