Show how many records were completed in current week and previous week

[bjbielski]

Here is my current formula, however, its giving me a negative number rather than a positive.  The result is giving me how many records were completed last week based on the "completion_date".



Previous Week: Sum(+Year([Completion_date])*53+DatePart("ww",[Completion_date])=Year(Date())*53+DatePart("ww",Date())-1)

Result: -1 and thinking is should be 1

I also need a formula to show me how many records were completed this week. Please help.

[pbaldy]

If I'm following it right, you're summing a Boolean expression (X=Y), so the result of -1 means True or 1 true result, since true is represented by -1. Does it return -2 when you think it should be 2? If so, meaning it returns the correct result but negative, you can wrap the whole thing in the Abs() function.

[bjbielski]

pbaldy...that worked. thank you very much

[pbaldy]

No problemo!