Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
# of Picks = "begin + added picks cumulative - completed picks cumulative".
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
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()))
Please find the attached QVW with my actual data.
Yes, fixed as you suggested, stalwar1
Do you really need that 2nd dimension?
PFA
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)))
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.
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.