Sum a Gallery in Powers to set the Default value in a form
Not sure what I am doing wrong here and the error not making sense. I have a Detail Form and Gallery of records related to it by setting the Items of the Gallery to the form. So I was thinking it would be easy to set the value of field (on the form) from the gallery. Specifically sum the total of the gallery and update the "Total Sales" field of the form. My intent was to set the default value of the field to 'Sum(Gallery3.AllItems,Amount)". Make sense right?? But NO. For some reason I am getting a "Rule creates a circular reference between properties"... How? ... Why?
Anyway, any help would be appreciated or a workaround would be great.