Range Sum

[varunreddy]

Hi All,

I am trying to calculate the sum using the prior number which is aggregated by CDE and DimensionA.

Now I am trying to calculate cumulative observations, which is

A Completeness 25000

A Validity           26000 (25000+1000)

A Accuracy        26500.(25000+1000+500)

I got this using the expression:

RangeSum(Above(Total aggr(sum([Ruleset Failing Records]),[Associated DQ Dimension]CDE Name]),0,RowNo()) .

When I select Accuracy I get 500, instead of 26500.

Can anyone cme across this situation?

Thanks in advance!

Message was edited by: Varun Reddy

[varunreddy]

Can we sort the order in the backend before loading?

[sunny_talwar]

Sure you can....

If these 3 are the only values that would ever show in DQ Dimension. Add an inline load after environmental variables but before anything else in your script

Environmental Variables....

Temp:

LOAD * INLINE [

DQ Dimesnion

Completeness

Validity

Accuracy

];

Other script....

DROP Table Temp;

[varunreddy]

How will this inline change the sort order for the dimension, as we are dropping the inline table?

[sunny_talwar]

Its just creating a sort order... once DQ Dimension comes in, it will pick that same sort order.... and later you don't really need the dummy table because you have transferred the sort order to your actual DQ Dimension.

[varunreddy]

Cool, Thanks

[navaskhan]

RangeSum(Above(Total Sum(Failed),0Row(Total))