finance | lob | total | |
total recons | 981 | 289 | 1270 |
ranking | 99.89 | 98.29 | |
weighted average ranking | 77.15912598 | 22.36677953 | 99.52591 |
formula used | B5*b4/d4 | c5*c4/d4 |
Hi @Sirishayca Would you be able to provide more in words what you're trying to accomplish rather than the Excel formula you used? Alteryx doesn't work in columns like Excel where they're labelled using the alphabet.
Additionally, could you provide what expressions you have already tried in Alteryx so we are best able to help show you where maybe you went wrong?