Rangesum with multiple dimensions

[varunreddy]

Hi All,

I  am new to the RangeSum. I am trying to do the rolling sum with "Failed" records with multiple dimensions. I see that rangesum functionality is not working. I am attaching the Source file and the QVW.

Thanks in advance!

Cheers,

VK

Message was edited by: Varun Reddy

[Anil_Babu_Samineni]

From that data, Is this you are expecting?

[varunreddy]

I am expecting this:

Date	Driver	Country	CDE	Dimension	RangeSum
4/1/2017	BCBS	US	CDE1	Completeness	25000
4/1/2017	BCBS	US	CDE1	Validity	26000
4/1/2017	BCBS	US	CDE1	Accuracy	26500
4/1/2017	BCBS	US	CDE2	Completeness	25000
4/1/2017	BCBS	US	CDE2	Validity	26000
4/1/2017	BCBS	US	CDE2	Accuracy	26500

[Anil_Babu_Samineni · Accepted solution]

This?

RangeSum(Above( Sum({<Date= {'$(=vDate)'}>}Failed),0,RowNo(TOTAL)))

[varunreddy]

Thanks Anil. Can you also share the previous expression,

Cheers,

VK

[Anil_Babu_Samineni]

NP

RangeSum(Above(TOTAL Sum({<Date= {'$(=vDate)'}>}Failed),0,RowNo(TOTAL)))