How to join a string and float value in a calculated field using Tableau?

Question

I am trying to create a calculated field where the output is "x% Over the Goal", however cannot due to string and float values. Essentially, what I want is the following:

IF Actuals > Goal THEN Actuals/Goal+'Over Goal'
ELSEIF  Actuals < Goal then Actuals/Goal+'Under Goal'
ELSE 'At Goal' END

Is something like this possible? I've tried creating two separate calculated fields and concatenating them, but that does not work either.

Any help would be greatly appreciated.

Naga Vemprala · Accepted Answer · 2016-11-05 02:55:52Z

4

You Can achieve this in a single calculated field:

IF [Actuals] > [Goal] THEN STR(FLOAT([Actuals] / [Goal])) + "Over Goal"
ELSEIF [Actuals] < [Goal] THEN STR(FLOAT([Actuals] / [Goal])) + "Under Goal"  
ELSE "At Goal" END

answered Nov 5, 2016 at 2:55

Naga Vemprala

7284 gold badges18 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to join a string and float value in a calculated field using Tableau?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related