Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am struggling to exclude rown in a table where the total sums to zero.
This is an example of the load statement
LOAD
Autonumber(%Key_Entity) as %Key_Entity,
Autonumber(%Key_PL) as %Key_PL,
Autonumber(%Key_BS) as %Key_BS,
Autonumber(%Key_Groupcoa) as %Key_Groupcoa,
pl,
btop,
period,
bussline,
voucher_type,
voucher_no,
text,
sequence_no,
DataSource,
'Agresso' as DataTable,
currency,
cur_amount,
GBP
and this is an example of the table and the set analysis. I am just wondering id there is a way to exclude the zero numbers
sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, pl = {N01,N02,N03,N04,N06,R01}, groupcoa = {">5999"}>}GBP)
Many thanks
Have you tried to check 'Suppress Zero Values' on the presentation tab?
Yes I have. There are values in some of the lines but they sum to zero. I think QV shows the lines because there is data in them it just so happens that it sums to zero
Can you share us a sample app you are working on by scrambling your data?
Sorry I don't know how to scramble the data
Check this link:
Preparing examples for Upload - Reduction and Data Scrambling
Hi Paul,
Try to use calculated dimension something like that:
=IF(AGGR(sum({$<period = {">=$(vStartPeriod_CY)<=$(vEndPeriod_CY)"}, pl = {N01,N02,N03,N04,N06,R01}, groupcoa = {">5999"}>}GBP) , <List chart dimensions here>) <> 0, <Some of your Deminsions>)
Hope it will help.