Accumulation Not working for Calculating other columns

[maahivee]

Hello Guys - I have a simple requirement here, But for some reason it is not working..

In a straight table, i have columns  added picks, completed picks, which are regular calculations based on data from tables.

After that i have Begin, added picks cumulative and completed picks cumulative which are same calculations as above but i am giving "full accumulation" for these 3 columns.

And then i have # of Picks which is basically "begin + added picks cumulative - completed picks cumulative".

So when i am doing this # of picks column calculation based on the Full Accumulation columns, I would assume it showing results based on Full accumulation value for that row instead showing result based on the actual value..

Is there any thing i am missing here. or doing anything wrong. Please see the attached sheet for more data.

[maahivee]

# of Picks =  "begin + added picks cumulative - completed picks cumulative".

[Clever_Anjos]

This should work

Rangesum(

Above(Count({<StatusType={'Begin'}>}TransactionAmt),0, rowno()),

-Above(Count({<StatusType={'Added'}>}TransactionAmt),0, rowno()),

Above(Count({<StatusType={'Completed'}>}TransactionAmt),,0 rowno())

)

If doesn´t please share a sample of your qvw Preparing examples for Upload - Reduction and Data Scrambling

[sunny_talwar]

This you mean?

Rangesum(

Above(Count({<StatusType={'Begin'}>}TransactionAmt), 0, RowNo()),

-Above(Count({<StatusType={'Added'}>}TransactionAmt), 0, RowNo()),

Above(Count({<StatusType={'Completed'}>}TransactionAmt), 0, RowNo()))

[maahivee]

Please find the attached QVW with my actual data.

[Clever_Anjos]

Yes, fixed as you suggested, stalwar1‌

[Clever_Anjos]

Do you really need that 2nd dimension?

[Clever_Anjos]

PFA

[sunny_talwar]

Can you try this:

Rangesum(

Above(TOTAL Count({<StatusType={'Begin'}>}TransactionAmt), 0, RowNo(TOTAL)),

Above(TOTAL Count({<StatusType={'Added'}>}TransactionAmt), 0, RowNo(TOTAL)),

-Above(TOTAL Count({<StatusType={'Completed'}>}TransactionAmt), 0, RowNo(TOTAL)))

[maahivee]

Hello Anjos - I dont know why that same expression in that QVW you attached is not working in my actual QVW.

Giving the same numbers as before.

[maahivee]

Hello Sunny - If we look at hour 9 it should be 101+262-131 = 232 it is instead 332

hour 10 also  101+323-134 = 290 it is instead 421.