Sum problem

I am using a sum([db.field]) to sum the values in a group footer

It works fine except where the group fills a page causing the footer to apear at the top of a new page then the value in the sum is incorrect.

Can anyone help

Steve

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 6:55PM
    Use the extended syntax of the sum function
    [Sum([db."field"], bandname,1)]
    band name param is bandname of mdband as shown in object inspector
    1 param optional, gathers non visible values if used.
    ;)
  • edited 6:55PM
    Thanks Gord
    good to see you are still about!
    Steve

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.