Replace rows with 0 as -

Question

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

Business Case -  Alteryx Workflow for PAR_V2.yxmd

atcodedog05 · Answer

Hi @hemantkumar622

You can try formula like below.

Workflow:

Hope this helps : )

Business Case -  Alteryx Workflow for PAR_V2 (1).yxmd

hemantkumar622 · Answer

Please find the attached input

JPM WM Marketing by Concept Line and BC_09172021.xlsx

atcodedog05 · Answer

Hi @hemantkumar622

Can you please provide input file for the attached workflow.