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
Super User
4 years ago

Anonymous , New column

 

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