9 Replies Latest reply on Aug 4, 2016 2:29 AM by Dilyana Suleymanova

# Mistake by the table calculation

Hi there,

i have a question to a simple table calculation.

It is looks like this:

What I want to calculate is

54/1676 = 3,2%

78/1676= 4,6%

.

.

.

105/1630=6,4%

As you can see the results by Tableau are false. I don't know why?

There are some filter as you can see. The Dimension Month is a formular:

DATE(if [E-Mail Opt-In geändert am]< #01/04/2016# then "Start value"

else STR([E-Mail Opt-In geändert am])

END)

Could it be the mistake?

Please find my workbook in attachment

Many thanks in advance!

• ###### 1. Re: Mistake by the table calculation

Change your formula to SUM each anzahl - i.e.

...

WHEN 3 THEN SUM([Anzahl der satensatz])/1676

WHEN 4 THEN SUM([Anzahl der satensatz])/1676

...

• ###### 2. Re: Mistake by the table calculation

HI Andrew,

Unfortenately it doesn't help:

Do you have may be any other ideas?

Thank you!

• ###### 3. Re: Mistake by the table calculation

Ok, change the first part of the formula to CASE ATTR(MONTH([EMAIL...]))

• ###### 4. Re: Mistake by the table calculation

That's what i was also doing

Where i was confused is where the 78 came from in April?! i get 34...

34/1676 = 2.03% as below

• ###### 5. Re: Mistake by the table calculation

Now it is better:

But I don't understand, why tableau doesn't calculate for "Null"? Well the Date by me is actually a formula.

• ###### 6. Re: Mistake by the table calculation

null is a special value and not equal to 0 or empty string

Write null

• ###### 7. Re: Mistake by the table calculation

Hey neighbour :-), don't be confused abou "34". I didn't post my original data.

I can't understand, why tableau dosn't calculate the first months "Null"?

Any ideas?

• ###### 8. Re: Mistake by the table calculation
\don't be confused abou "34". I didn't post my original data.\

Aha, good to know

I can't understand, why tableau dosn't calculate the first months "Null"?

Any ideas?

I think you haven't seen my previous message... null is special and not equal to 0 or ""

so rather than CASE = 0

swap to  CASE = null

Should be working...

• ###### 9. Re: Mistake by the table calculation

Thank you guys, it works

WIsh you a nice day!