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

[Anonymous]

Preparing examples for Upload - Reduction and Data Scrambling

[sunny_talwar]

I don't understand the point of using Aggr() function if you have both your Aggr() dimensions as the chart dimension? What exactly are you trying to do? Do you have more dimensions then the ones you are showing or what is the requirement?

[varunreddy]

I don't see option to upload.

This is what I see. Can you navigate me, I will upload.

[sunny_talwar]

Check here:

Uploading a Sample

[varunreddy]

Sunny,

I don't have any other dimensions. I have added my QVW and source file. Please take a look.

[sunny_talwar]

Check the attached

RangeSum(Above(Sum({<[DQ Dimesnion]>}Failed), 0, RowNo())) * Avg(1)

[varunreddy]

Thanks for the response. But, It is showing 26500 for all the selections.

[sunny_talwar · Accepted solution]

You used a sort expression which needed to be fixed as well

Match(Only({1}[DQ Dimesnion]), 'Completeness', 'Validity', 'Accuracy')

[varunreddy]

Thanks Sunny,

It's working

Cheers,

VK

[varunreddy]

Robin,

Thanks for your response

Cheers,

VK