Executing IF_THEN_ELSE in Tableau

0 votes
I have the following graph:

I would like to calculate lapsed rate which is sum of lapsed value divided by sum of inforce value. I use the formula below in calculated field.

abs(sum(if[Status]='lapsed'then[TotalAmount]end))/abs(sum(if[Status]='inforce'then[TotalAmount]end))

However this formula also pick the value from Q2 (quarter 2) 2016.
What I want ?
First check if any quarter does not contain both inforce value and lapsed value then skip that quarter.
In this case I need to calculate lapsed rate which does not include Q2 2016. Can someone help me on how can i do it?
Aug 13, 2018 in Tableau by Atul
• 10,240 points

edited Aug 14, 2018 by Atul 38 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Tableau

0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
838 views
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,550 points
1,280 views
0 votes
1 answer

Dropdown to change x-axis in Tableau

You need to create a  str datatype parameter ...READ MORE

answered Apr 3, 2018 in Tableau by QueenBee
• 1,810 points
64 views
0 votes
1 answer

How to use a IFF statement in Tableau

Use this syntax -  IIF(([Avg_sale] > [Today]),STR([Avg_sale ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
192 views
0 votes
1 answer

MDX query in Tableau pivot table

You can view them here - \My Documents\My ...READ MORE

answered Apr 5, 2018 in Tableau by QueenBee
• 1,810 points
72 views
0 votes
1 answer

How can I count the aggregate function in Tableau

Create two calculated fields one for 100's ...READ MORE

answered Apr 5, 2018 in Tableau by Atul
• 10,240 points
1,864 views
0 votes
1 answer

Executing IF-THEN_ELSE before Executing Calculation - Tableau

You can use a combination of a ...READ MORE

answered Sep 28, 2018 in Tableau by ghost
• 1,790 points
49 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
2,240 views
+1 vote
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
103 views