Think the MIN should be LMIN Dan Goldberg
From: [email protected] [mailto:[email protected]] On Behalf Of Patti Jakusz Sent: Thursday, October 22, 2015 1:41 PM To: Dan Goldberg Subject: [RBASE-L] - Using MIN function in a Report Hello, I have a report that calculates 3 variables and I want to use the minimum of the 3 in an calculation that gets printed on the report as well as subtotaled. So I've tried setting vnewvar = (MIN(.var1, .var2, .var3)) but it doesn't like it. I can't seem to figure out the syntax. This should work, right? I'm using this for a report that lists the number of home visits each client is supposed to have. Normally 2 visits per month, unless she enrolled in the month or exited the program in the month. So # of visits I figured would be 28/14 or 2. var1 = 28 Var2 = End of month minus enroll date Var3 = End of month minus exit date Then I will use the minimum number in my equation to calculate the number of visits she's supposed to have. If it's less than 28 and I truncate, I'll get 1 visit. Is there any easier way? Thanks, Patti
