Hi Team, I have following dataset DATASSRRCCTOTALA10102040B15203065 Expected output: DATASSRRCCTOTALA10102040A ( %)25%25%50% B15203065B ( %)23%31%46% While using formula tool I would like to have total's should be picked dynamically.

% Calculation

Hi Team,

I have following dataset

Expected output:

While using formula tool I would like to have total's should be picked dynamically.

Updated

@BRRLL99 Another method

Hi @BRRLL99 , you can do this with some creative cross-tabbing and transposing:

Hope this helps!

is it possible to build same workflow dynamically with less tools

How about this?

IF I'm using Round in my original data set I have percentage values less than 1

like 0.81 or 0.99 etc it is showing as "0"

and I would like to have percentage sign shown instead of

expected output:

A -- 8% , 0.86%, 15% etc

B -- 0.67% , 5.4% etc

Updated

@BRRLL99 Another method