Skip to Content
0
Mar 05, 2009 at 09:47 AM

Display column total on the header using Formatted Search

709 Views

Hello,

I'm trying to create a FS on a Sales Order header (UDF) that will summarize a

column from the row level.

For example, I'd like to display the sum of the quantity in the header.

I've tried the following syntax: Select sum($[$-38.11.NUMBER]) but I get

only the first line as query result and not sum of all lines.

Is it possible to get the column total using FS? If so, what should be

the syntax?

Thank you in advance,

Maya