Sum expression for Column

(0) Share

Report

Posted on by Shabir Ahmad

3,110

Hi Experts,

I have a requirement, our company vendor developed a cust againg report only 6 columns company told me to increase the colum to 13 column i did it. Now in cust aging Report is sum on row base that's means the of a row will be shown for one customer, but my organization is demanding for column base that's means what will be the total amount of 1 last month for all customer, what will be for last 2 months total for all customers,

Please check the above image for your clearification.

Best Regards,

Shabir Ahmad

I have the same question (0)

All responses (9)

Answers (1)

Suggested answer

Gunjan Bhattachayya 35,423 on at

Like (1)

Report
Hi Shabir,

Not sure if the original customer aging report has been modified here or a new one has been built from scratch. If the same report is modified, then it is using CustAgingReportTmp as the datasource. You can use an expression like this to get the sum of the column

=Sum(Fields!Balance01.Value)

You can replace "Balance01" with the field you are using in the report.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

Hi Gunjan Bhattacharyya,

How can do that such as( Sum(fields which i will take are all expressions(=Sum(iif(DateDiff("d", Fields!DueDate.Value, Parameters!AsDate.Value) >= 0 And DateDiff("d", Fields!DueDate.Value, Parameters!AsDate.Value) <= 30, Fields!AmountCur.Value, 0))))

Best Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Hi Shabir,

Are you not storing these values displayed in the column in a field in the temporary table?

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

Hi Gunjan Bhattacharyya,

There is no, temp table only two table has been taken for query as data source and this query base report all the calculation and logic has been done using these expressions. So there is no temp table.

Best Regards,

Shabir

Was this reply helpful? Yes No
Gunjan Bhattachayya 35,423 on at

Like (1)

Report

Could you please share the query being used and the expression in the report displaying the amount values?

Was this reply helpful? Yes No
Suggested answer

Ibrahiman 40 on at

Like (1)

Report

Hi Shabir,

If your current Aging periods columns calculation which are grouped by Customer level are correct, then all you need to do is to remove customer row group from the table and keep same expression on the aging periods columns. As you can't show total balance on columns level while you are already splitting the values on row level based on customers.

Hope this helps,

Was this reply helpful? Yes No
Suggested answer

Ibrahiman 40 on at

Like (0)

Report

The expressions seems fine, don't change expressions on the columns. only remove customer row group from table design, but firstly copy same columns from Customer Row group to Table footer section so the summation will be on whole data level.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

Hi Ibrahiman ,

Now, this was group by Posting Profile, i removed group by posting Profile , what will be process.

Best Regards,

Shabir

Was this reply helpful? Yes No
Verified answer

Ibrahiman 40 on at

Like (1)

Report

Hi Shabir,

Copy same columns of Aging Periods Calculation that was on Customer Row group to (Table footer) section so the summation will be on whole data level.

Was this reply helpful? Yes No