We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Need help with an exercise

RaviPM10
7 - Meteor

Hi Team, Can you please assist me with below exercise 

 

have following data, which is coming from data base as below 

NameMarket ValueFund return Fund BN WeightFund End weightBM BGN WeightBM END Weight
Domestic1002.3222525252525
International2002.4212325252525
World2003.14625550505050
Total5002.0235100100100100

 

need output as below 

NameMarket ValueFund return Fund BN WeightFund End weightBM BGN WeightBM END Weight
Total5002.0235100100100100
Domestic100     
International200     
World200     

 

4 REPLIES 4
cjaneczko
13 - Pulsar

Use a Multi Field Formula and select all the numeric fields except Market Value. Then use the following:

 

 

 

if [Name] != 'Total' then null() else [_CurrentField_] endif

 

 

 

If you want the Total on top, put a sort tool after that and sort Market Value descending. 

 

image.pngimage.png

 

RaviPM10
7 - Meteor

I tried but not getting desire output

RaviPM10
7 - Meteor

its working Thanks for your help

cjaneczko
13 - Pulsar

Glad it worked. 

Labels
Top Solution Authors