Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Thanks for your help. I need to do this in a ID column. Autonumer column for Project and Time, I need that autonumber start again in 1 for each group of projects
ID | TIME | PROJECT | SUM |
1 | 1 FEB | AAA | 1224 |
2 | 1 MAR | AAA | 9876 |
3 | 1 APR | AAA | 7654 |
1 | 1 FEB | BBB | 5432 |
2 | 1 SEP | BBB | 1234 |
1 | 1 MAY | CCC | 4444 |
2 | 1 JUN | CCC | 1234 |
3 | 1 JUL | CCC | 3456 |
4 | 1 AUG | CCC | 5634 |
Autonumber(Proyect&Time) not works, create a consecutive but not start again in 1 for each project.
Thanks a lot.
You just need to add the another parameter which is available with the autonumber() function , as below
Autonumber(Project&Time,Project) as ID
if(PROJECT=previous(PROJECT),rangesum(Peek(ID),1),1)as ID
-- also don t forget to order by PROJECT, TIME,SUM
You just need to add the another parameter which is available with the autonumber() function , as below
Autonumber(Project&Time,Project) as ID
Vineeth
Thank you very much, I was really missing a small detail that you kindly helped me to discover!!!!
Thank you very much for your help, Vineeth gave us a slightly more efficient solution in terms of resources, however, yours works too, thank you very much.