Forum Discussion
To count max in row
hi amitchandak thank you for the responce. Pleases help me i am totally confused andunable to replicate the formula below. Please tell me if it is a Calculated Measure or Column. Actual Table name is PPR and Column names are Tool Number and Date Diff column names are T0,T1,T2,T3 & T4.
harshagraj , I suggested measures. If this did not work
Can you share sample data and sample output.
Hi amitchandak i tried the other calculation but unfortunately it didnt work. Please find the below sample data.
Eg: Tool Number 9 - A is at T3 so it should not be counted in T0,T1,T2.
Tool Number 41- A is at T2 so it should not be counted in T0,T1 & T3
Here the total tool count of tool number is 100. The required output is I need count of T0,T1,T2,T3
(Hint:Count of Tool(100)= Count(T0)+Count(T1)+Count(T2)+Count(T3))Hi amitchandak i tried the other calculation but unfortunately it didnt work. Please find the below sample data.
Eg: Tool Number 9 - A is at T3 so it should not be counted in T0,T1,T2.
Tool Number 41- A is at T2 so it should not be counted in T0,T1 & T31-A 0 2-A 4 3-A 4 4-A 0 5-A 0 6-A 4 7-A 0 8-A 13 9-A 17 18 47 19 10-A 17 15 18 26 11-A 17 15 18 26 12-A 16 21 14 21 13-A 19 75 11 12 14-A 19 24 35 39 15-A 15 15 32 8 16-A 15 15 36 8 17-A 15 15 32 8 18-A 15 15 32 8 19-A 15 15 32 8 20-A 15 15 36 8 21-A 19 26 36 63 22-A 60 14 21 8 23-A 60 14 21 8 24-A 60 14 21 8 25-A 60 14 21 8 26-A 18 22 61 0 27-A 6 6 110 2 28-A 19 23 45 29-A 20 38 4 0 30-A 22 38 4 0 31-A 22 38 4 0 32-A 20 24 19 69 33-A 19 24 66 34-A 22 38 4 0 35-A 22 24 15 72 36-A 57 59 84 25 37-A 3 -6 47 37 38-A 23 22 62 33 39-A 23 23 55 40-A 15 16 100 9 41-A 24 25 58 42-A 24 22 51 43-A 28 34 24 44-A 17 26 14 48 45-A 15 -2 10 11 46-A 15 -2 10 11 47-A 15 -2 10 11 48-A 36 41 56 18 49-A 22 22 -22 0 50-A 36 42 57 24 51-A 23 26 33 0 52-A 4 4 53-A 38 37 3 40 54-A 44 49 4 55-A 31 39 69 8 56-A 43 43 4 68 57-A 16 59 58-A 49 51 10 11 59-A 49 51 10 11 60-A 49 51 10 11 61-A 27 29 0 0 62-A 30 -58 63 0 63-A 25 -49 0 0 64-A -53 0 0 65-A 25 -49 0 0 66-A -54 0 0 67-A 25 -49 0 -4 68-A 20 25 32 5 69-A 13 -49 83 0 70-A 13 -49 83 -19 71-A 26 31 14 0 72-A 26 31 14 5 73-A 26 31 46 5 74-A 56 63 34 23 75-A 40 -46 76-A 67 67 10 5 77-A 67 67 10 5 78-A 67 67 10 5 79-A 148 21 14 12 80-A 148 21 14 12 81-A 148 21 14 12 82-A -44 0 0 83-A 30 35 17 0 84-A 30 35 17 0 85-A 29 29 86-A 5 -43 45 18 87-A 59 69 28 88-A 40 89-A 40 90-A 40 91-A 15 18 2 92-A 15 18 1 93-A 15 18 1 94-A 15 18 1 95-A 15 18 5 96-A 15 18 1 97-A 15 18 1 98-A 22 -40 75 -19 99-A 22 -40 75 0 100-A 23 -39 74 46 Hi amitchandak i tried the other calculation but unfortunately it didnt work. Please find the below sample data.
Eg: Tool Number 9 - A is at T3 so it should not be counted in T0,T1,T2.
Tool Number 41- A is at T2 so it should not be counted in T0,T1 & T3hi amitchandak parry2k could you please help me?