Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can we sort the order in the backend before loading?
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;
How will this inline change the sort order for the dimension, as we are dropping the inline table?
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.
Cool, Thanks
RangeSum(Above(Total Sum(Failed),0Row(Total))