Calculating one column from other column

[Alteryxexpert]

I have Data Below 

sub item	item	Split	Value	Date
Chair_4	Chair		790,000	12/31/2023
Chair_3	Chair		45,454	12/31/2023
Chair_2	Chair		777555	12/31/2023
Chair_1	Chair		565,666	12/31/2023
Chair_0	Chair		888,999	12/31/2023
Table_4	Table		790,000	12/31/2023
Table_3	Table		45,454	12/31/2023
Table_2	Table		777555	12/31/2023
Table_1	Table		565,666	12/31/2023
Table_0	Table		888,999	12/31/2023
Chair_4	Chair		790,000	1/1/2024
Chair_3	Chair		45,454	1/1/2024
Chair_2	Chair		777555	1/1/2024
Chair_1	Chair		565,666	1/1/2024
Chair_0	Chair		888,999	1/1/2024
Table_4	Table		790,000	1/1/2024
Table_3	Table		45,454	1/1/2024
Table_2	Table		777555	1/1/2024
Table_1	Table		565,666	1/1/2024
Table_0	Table		888,999	1/1/2024

I want to calculate the split(3rd Column) Based on the value column.

The Logic is :

For a specific period(31-12-2023) the calculation for chair_4 should be, 79000/(790,000 +45,454 +777555+565,666 +888,999), and for chair_3 it should be 45454/(790,000 +45,454 +777555+565,666 +888,999) and it should calculate in the same way for all the items.

Datatype:

Value:Numeric

Date:Date

Rest all String

[aatalai]

the replace to remove the ", " if you don't have them as you r data is already numeric, then you can skip it/remove it