Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
alteryx Community

# Alteryx Designer Desktop Discussions

## Calculating one column from other column

8 - Asteroid

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

10 REPLIES 10
14 - Magnetar

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

Labels