Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Missing Count Values

padawanRZ
6 - Meteoroid

Hello Community,

 

I'm perplexed as to why the values are not being counted correctly in this workflow. Kindly assist.

 

Input data.PNG

output error.PNG

 

 

 Correct output should be:

 

MAL CodesTotal DirectoriesBN Populated  BN %BD Populated  BD %
ATUS3 {SRZ,FS}8787.50%00.00%
GPAS-VICC {SRZ,FS}9888.89%9100.00%

 

1 REPLY 1
gawa
16 - Nebula
16 - Nebula

hi @padawanRZ 

My observation:

In Formula(23), 2nd expression

Output Column should be "Business Description" though you specified "Business Name"

image.png

By changing this, the desired output came out as attached.

image.png

Labels
Top Solution Authors