Simple Table & Total for Some Values

[#1]

Hello!

I have a simple table like this:

Anomaly	Quantity	%	Observations
	30	100%	10
With Anomaly	15	50%	3
No Anomaly	10	33,33%	5
Pending	5	16,67%	2

Anomaly is a Calculated Dimension

Quantity, % and Observations are Expressions

The Calculated Dimension for Anomaly is the following:

= IF (ISNULL (FLAG_ANOMALY), 'Pending', FLAG_ANOMALY)

The thing is that I want my table to only have the following: With Anomaly and No Anomaly (I don't want to show the Pending).

But if I do that and I take out the null values from the table, I get something like this (look at the %😞

Anomaly	Quantity	%	Observations
	25	83,33%	8
With Anomaly	15	50%	3
No Anomaly	10	33,33%	5

And I want to show the 100% for those two values...

Maybe my Expression for % has something to be with that, because I count over the total:

COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)
/
COUNT (TOTAL {$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)

Is there any way to show the total 100% only for With Anomaly and No Anomaly?

How could I do that?

Thank you!!!

[tresesco · Accepted solution]

Use the expression:

=COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)

and mark 'Relative' in the expression tab.

[jagan]

Hi,

Try like this

Expression

=COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)

Now select the 'Relative' option in Expression tab, In Dimension table select the Dimension and check the Supress When Value is Null option.

Hope this helps you.

Regards,

Jagan.

[CELAMBARASAN]

Use Relative or

COUNT ({$<ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)
/
COUNT (TOTAL {$<FLAG_ANOMALY={'*'},ID_TIME_DATE#={">=$(='$(vDateFrom)')<=$(='$(vDateTo)')"}>} DISTINCT ACCOUNT_ID)