AnsweredAssumed Answered

Need better Day Calculations that don't give -numbers when set to "Inactive"

Question asked by MarcMcCall on Mar 3, 2012
Latest reply on Mar 5, 2012 by philmodjunk


Need better Day Calculations that don't give -numbers when set to "Inactive"


I need better day calculations.  When status is set to inactive it gives me a number like this "-734541" This is the formula I'm using

"If(Status="Active"and IsEmpty(Date_Start) = 0; Get(CurrentDate)) - Date_Start + 1"  This counts there first day as 1 which i need.

When  Status is set to "Inactive" I would like it to stop counting and not display the negative #.  I need to leave the Start date in the field when set to Inactive for possible reference at a later time, so I cant just remove the date.  I also want to use the new formula fo other day calculations fields I'll just change the parameters.

"If(Status="Active"and IsEmpty(StartDate123 )= 0; Get(CurrentDate)) - StartDate123"

I have 10 total day counters

Date_Start, StartDateReading, StartDate123, StartDate4, StartDate5, StartDate6, StartDate7, StartDate89, StartDate101112, StartDateAll

Days, DaysReading, Days123, Days4, Days5, Days6, Days7, Days89, Days101112, DaysAll

I'm using the Days calculation results in Summary Average Fields to calculate the average of how many days the ACTIVE clients are in one of these areas.