Rick,
I tried the int(calculate...), it didn;t like that. Thanks for the tip on the rest though!!!
Happy Thansgiving!!
>Perry,
>
>Have you looked at the default settings (SET DECIMAL or Tools/Options)? Or maybe you could do something like
>INT(CALCULATE .....)
>
>Rick
>
>>Rick,
>>
>>That's the exact reason why I use Calculate and Count. Plus I can set filters right in the statements. Here's something for ya: when I do my Calculate statement, the value passed to my variable has 2 decimal places by default. Can I eliminate these decimal places??
>>
>>Perry
>>
>>>Jason,
>>>According to Hacker's Guide, CALCULATE SUM() and CALCULATE AVG() are about twice as fast as SUM and AVERAGE...That could be one reason for using it instead.
>>>
>>>Have a Happy Thanksgiving,
>>>Rick
>>>
>>>>It should go top implicitly without you interfering. I am curious though why you chose this methodology?
>>>>
>>>>Regards
>>>>
>>>>JTryon
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.