Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You can try this.
=sum(if(GJACCT='230000',39033.38,GJAMT))
For the zero problem, uncheck the "Supress Zero Values" under chart properties>presentation.
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.
With that formula it doesn't allow my if statement to work correctly.
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.