Counting redundant rows using by variables - different outcome for continuous and nominal/character by variables?
Here I am counting redundant rows based on info held in 2 columns (Batch ID & Value [concentration]).Col Cumulative Sum( 1, :Batch ID, :"Value [concentration]"n )
However, based on whether Value [concentration] is formatted as continuous or character variable in my table, a different result is obtained (see screenshots below). Outcome with Value [concentration] as continuous variable (not what I wa...