Replace rows with 0 as -

[hemantkumar622]

Hi Team,

I am trying to build a logic, which should say in Col name " FY Outlook vs. FY Budget"  as per below

 Replace all the rows with  zero (0) in "FY Outlook vs. FY Budget" as hyphen (-)

Currently rows with Zero(0) is showing blank.

Attaching my worflow

[cmcclellan]

I'd advise against doing this in Alteryx, but I'd be changing a few other things in your workflow as well

- Change Outlook vs Budget to a float (and remove the ReplaceFirst logic as well)

- Your Marketing 2 data source will only be 1 row, 4 fields. You could probably do that with some calculated fields in Tableau with Marketing 1

- the "show 0 as -" should be handled in Tableau, because this gives you the ability to SUM Outlook vs Budget if you need to

Also, think about the corporate information that you are showing in that workflow.  There's server names, directory structures, etc that could be considered confidential information.

[atcodedog05]

Hi @hemantkumar622 

Can you please provide input file for the attached workflow.

[hemantkumar622]

Please find the attached input

[atcodedog05]

Hi @hemantkumar622 

You can try formula like below.

Workflow:

Hope this helps : )