Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Divide based on a grouped column

Hello everyone,   I have a table with 5 columns [Date, ID, ZipCode, Numeric, Condition]   Date ID ZipCode Number Condition 27/03/2020 A MTS 117525 Yes 27/03/2020 B MTS 117525 ...
Division
SUMMARIZE
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , New column

     

    new column =divide( [Number], countx(filter(Table, [zip code] =earlier([Zip Code]) && [Condition]= "Yes" ), [ID] ) )

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

Anonymous , New column

 

new column =divide( [Number], countx(filter(Table, [zip code] =earlier([Zip Code]) && [Condition]= "Yes" ), [ID] ) )

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    When the condition is "No" the new column should be 0.

    The output should be 39175 | 39175 | 39175 | 0 (these are rows). 

    The zipcode can change along the table