You need to sign in to do that
Don't have an account?
George Laird 39
PREVGROUP VAL? Did stage move forward?
Hello All,
I've got a custom object named POV and I'm taking a weekly analytic snapshot of where the stage was at the snapshot time. I'm also assigning a number value to each stage via formula field. When i create a matric report i can see each week the snapshot was taken and the value of the formula field. I basically want to look at the last time the snapshot was taken (the previous row) and if the stage number got larger, that means the stage moved forward! So, in this case i can return a 1 if it moved forward and a 0 if it moved backwards or stayed the same.
I'm not having luck with this formula. I'm trying to use PREVGROUPVAL, but it's looking at the record previous even if it's for a different record.
So in the screen shot below, how would i write a report formula to say, in this example, "If the sum of stage counter for week 7/19 is greater than that of 7/12 for that given POVID, return 1, otherwise return 0?
Thanks in advance!
George
I've got a custom object named POV and I'm taking a weekly analytic snapshot of where the stage was at the snapshot time. I'm also assigning a number value to each stage via formula field. When i create a matric report i can see each week the snapshot was taken and the value of the formula field. I basically want to look at the last time the snapshot was taken (the previous row) and if the stage number got larger, that means the stage moved forward! So, in this case i can return a 1 if it moved forward and a 0 if it moved backwards or stayed the same.
I'm not having luck with this formula. I'm trying to use PREVGROUPVAL, but it's looking at the record previous even if it's for a different record.
So in the screen shot below, how would i write a report formula to say, in this example, "If the sum of stage counter for week 7/19 is greater than that of 7/12 for that given POVID, return 1, otherwise return 0?
Thanks in advance!
George