Question on how to calculate a result
Hello,
I am trying to calculate a solution using Aperture Data Studio. I have a table (as shown on the example screenshot below). For each ID I want to divide the values between levels to see if I get a an odd number. For example:
For ID 1 : 1000:100 =10, 100:10 = 10, 10:5=2 Result = True
For ID 2 : 18:5=3.6, 5:2=2,5 Result = False (as I am getting odd numbers)
ID3: 8:4 =2 Result = True
I would be grateful for any tips
Answers
-
It looks like you want to sort the data by the Value and ID columns then use the Get Cell Function to get the value from the row below the row being evaluated. It wont be the most performant process, but should work
Something like this (CurrentRow and Next Row are Variables using Current Row Function):
0 -
I thought of another, better, approach using your Level column. Create a column Level2 which is Level minus 1 then Lookup the first Value for the ID AND where Level2 = Level
ID || Value || Level || Level2 || Lookup || Evaluation
1 || 1000 || 4 || 3 || 100 || IsEven(1000/100=10)Filter where ID has a False Evaluation
0
