Display 0 values in straight table

[#1]

I need to have accounts display 0 values instead of not showing the account at all when the accounts value is 0. The other problem is I need to incorporate it into the value and I already have this included in the expression.

=if(GJACCT='230000',39033.38,sum(GJAMT))

Have no idea how to incorporate that into what I already have. Thanks in advance.

[#2]

You can try this.

=sum(if(GJACCT='230000',39033.38,GJAMT))

[fernandotoledo]

For the zero problem, uncheck the "Supress Zero Values" under chart properties>presentation.

[#4]

I have a bookmark that has certain account numbers that are selected and if I uncheck the suppress when zero option, it shows all of my accounts. Some how I need it to show only my bookmarked accounts, but show my bookmarked accounts with 0 as a value as 0, instead of just leaving them out.

[#5]

With that formula it doesn't allow my if statement to work correctly.

[fernandotoledo]

You can load a table mapping the accounts you want to show in your chart. something like

AccountMapping:
load * inline[
 Account, MappedAccount
 A, A
 B, B
 C, C
];

then you use in the chart the MappedAccount as the dimension, and check Properties>Dimensions>"Suppress When Value is Null"

Then you see only the accounts mapped in the table.