problem with sum

I have a system text object on a report with the following text/formula

[SUM(<Summary."occ">,MasterData1)]

In a test report I have a column with the numbers (for summary.occ) 12, 33 and 42

rather than my total being the sum of all three numbers, i.e. 87 I get a concatenation of all three numbers, i.e. 123342

has anyone seen this before or know what i am doing wrong.

Cheers

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 7:02AM
    "I have a system text object on a report with the following text/formula"
    in what band is this text object located ? must be correct footer, page footer or summary,
  • gpigpi
    edited 7:02AM
    Do you use latest FR? What type of <Summary."occ">? Numeric or string?
  • Hi I am using 4.13.1

    The object is on a reportsummary band

    summary.occ is numeric

    thanks
  • gordkgordk St.Catherines On. Canada.
    edited 7:02AM
    [SUM(<Summary."occ">,MasterData1,2)]// the 2 is for running total
    if that doesn't work try the latest version 4.14.7

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.