Number of days calculation for admission and discharge fields

#1

I am creating an app for a non-profit medical facility serving people experiencing homelessness. The organization needs two tracking data points:

  1. Total Days of Care to date

2)Total Days of Care Upon Discharge

 

I am have created calculations for both #1 and #2 but as you can see below, as the client is still a resident, the Total Days of Care Upon Discharge  shows a negative number, which is confusing to users. 

 

Calculation: (Updated_datetime - AdmitDate) / (60*60*24)

 

When the client is discharged, the Total Days of Care to date  field keeps counting the days which is different from the discharge date. Again, confusing for data reporting. 

 

Calculation: (DischargeDate - AdmitDate)  / (60*60*24)

 

I need a calculation that zero’s out (or leaves blank) the Total Days of Care Upon Discharge  field when the client is still a resident and then zero’s or blanks out the Total Days of Care to date  when the client has been discharged. 

 

Any ideas? 

#2

Hi David,

For your case, the IF function might be a good option.
The IF function is a function that changes the value to display depending on the specified conditional expression.

IF Function: Changing the Value to Display Depending on the Condition:
https://get.kintone.help/k/en/user/app_settings/form/autocalc/if_function.html

Could you try this out and see if you can achieve the desired process?
Hopefully, it helps.

#3

Hello Sean,

Tim at Kintone created the calculations for me, which solved my issue. 

Thanks for the input.