Sum of one cell equals the sum of remaining cells.

[OHMJAIN]

Hi All, I am pretty new to Alteryx and learning these days. For the file attached here, I need help in one thing.

The 'Fee (in Currency) for Role A is the total fees of all Role B added together. The calculation for Role B is easy i.e., opening * Fee % and I used the formula tool to recalculate it, but can you please help me out as how to arrive at the 'Fee (in currency)' for Class A. The end output should include the 'Fee (in Currency)' column and my recal and my difference column.

[fmvizcaino]

Hi @OHMJAIN ,

Is it a sample of your dataset? Do you need to do that type of manipulation for other group of rows as well?

If yes, would you be able to share a more complete dataset please?

Best,

Fernando v.

[OHMJAIN]

Hi,

I need the manipulation only for Role A, where the resultant figure in 'My Recal' cell for Role A should be the Sum of 'Role B' from the 'My Recal' cells. 

As you can see in the attachment, that the % for Role A is zero(because the total fees of role A is being contributed by role B), hence alteryx throws zero in the 'My Recal' cell for Role A, but for role B, it is correct and I get no difference.

The calculation for Role B is as follows.

(Opening * Fee %) = Fee(in Currency) = My Recal.

[himanshugirdhar · Accepted solution]

Hi

Check this solution from attached .

Please note: re point the data source to your file before running.

Thanks