CR11 Crosstab percent right in Total column only 1

[azoe]

I'm using a crosstab whose columns go by months and I have two formulas in the Summarized Field.
One is called //CrosstabGrossCollections
WhileReadingRecords;.001

and the other is called
//PercentOfGrossCollections
ABS(Sum ({aa_dch_PercentOfGrossCollections;1.PaidAmt}) % Sum ({aa_dch_PercentOfGrossCollections;1.ChgAmt}))

It is only correct in the Total column, not in the month column.
I pulled one month of data. The total PaidAmt is 1,904,305.91 and when you divide that by the total chgAmt of 2,819,175.61 you get .675
The total column displays 68% but the other column (the one month I pulled) shows 101.

Any ideas what the issue could be?
Thank you -

 

[lbass]

Change your formula to:

if abs({aa_dch_PercentOfGrossCollections;1.PaidAmt}) > 0 then
abs({aa_dch_PercentOfGrossCollections;1.PaidAmt} % {aa_dch_PercentOfGrossCollections;1.ChgAmt})

Add this to the crosstab and select "weighted average" as the summary and use {aa_dch_PercentOfGrossCollections;1.ChgAmt} as the field to weight by. Then, in preview mode, select the new summary and click on the % icon in the toolbar.

-LB

 

[azoe]

The total % is still right but now the other one is zero.

I'd still like to know how to do it even though I changed it to a regular grouping report instead of a crosstab.

I changed it to weighted with and picked chgamt.

Thank you

 

[lbass]

I tested my solution and it worked, so I'm wondering how exactly you implemented it in the inserted crosstab. Please explain and provide the contents of the formula you used.

-LB

 

[azoe]

This is what I have in the formula.

if abs({aa_dch_PercentOfGrossCollections;1.PaidAmt}) > 0 then
abs({aa_dch_PercentOfGrossCollections;1.PaidAmt} % {aa_dch_PercentOfGrossCollections;1.ChgAmt})

after inserting it in the crosstab I clicked on change summary, picked "weighted with" and chgamt was already selected.

I may have done something else wrong though, I'll try it next time - thank you.