QV Totals wrong

[#1]

Why does QV total this expression wrong? Total sb 23,821,797

Thanks for any help. Sharon.

Fiscal_Year	Fiscal_Period	Fiscal_Week	=Sum({$<Payment_Type={'M','C'},Carrier_Type_Carriers-={'F','2F',' '}, Carrier_Paid_Chk_Date={">=01/02/2010<=01/29/2010"} , Member_Paid_Chk_Date={">=01/02/2010<=01/29/2010"}>} Allowance_Total_Load_Hdr_from_Load_Dtl)
			$21,672,923.03
2010	1	1	$3,025,703.04
2010	1	2	$4,586,765.41
2010	1	3	$5,497,223.87
2010	1	4	$10,712,106.81

[#2]

Hello Sharon,

check out what kind of Total you are using for this expression. See: chart properties --> expression --> choose the according expr. --> Total Mode

HtH
Roland

[#3]

Yes, it is set to use the expression total.

[#4]

Hello again,

if this is wrong, try using "function-Mode" (third radio-button) and choose sum(). May be thats it.

RR

[#5]

Well, that worked for this extracted example but my actual page has several more dimensions so I added each dimension one by one to this example to see if the total would change and it did not. So now I have two pages with the only diff being one has more expressions (columns) but this column is still diff between the two. I am perplexed.

Sharon.

[#6]

Hi Addington,

Addington wrote:Well, that worked for this extracted example

thats what I can do for you so far. When adding more dimensions the virtual cube changes of course and I do not know what you are expecting then. For digging deeper: posting an exam app would be helpful. Then we both and the community can figure out more.

RR