Forum Discussion

Qrew Trainee

5 years ago

Finish Date Formula

Hey everyone, I'm attempting another formula without success. I have a start date, and a Rich Text - Formula field that calculates my final numbers to display a total in Days: (ToText(Round(([3...

Formulas and functions

Qrew Cadet

5 years ago

I think you just have misplaced parenthesis.
Try this:

ToText(Round(([3. Close Duration]+[3. Finish Duration]+[3. Rough Duration]+[3. Sub Duration])/8, 0.01))& " " & "Days"

------------------------------
Ahuva Brown
------------------------------

Qrew Trainee

5 years ago

Thanks again!

Also, I'm not quite sure how to add an if is null function to this so that if there is no data, Days won't display. Right now every field displays 'Days' even if there is no calculation in that field. Can I use 'IsNull' to say if there is no data, then leave the field blank? Sorry still fairly new to these formulas within quickbase!

------------------------------
Alex Bennett
------------------------------

AhuvaBrown
Qrew Cadet
5 years ago
In this case, I'd use a formula variable. I chose to name the variable numOfDays, but you can use whatever name you want.

var text numOfDays = ToText(Round(([3. Close Duration]+[3. Finish Duration]+[3. Rough Duration]+[3. Sub Duration])/8, 0.01))& " " & "Days";

If($numOfDays != "0", $numOfDays & " " & "Days", " ")

If that doesn't work, try it this way. Depending on how you set up your fields, an empty result will either show up as 0 or " ":

If($numOfDays != " ", $numOfDays & " " & "Days", " ")

------------------------------
Ahuva Brown
------------------------------
AlexBennett3
Qrew Trainee
5 years ago
I also wanted to see if you had any opinions on how to formulas are read, so right now I don't know if they are accurately displaying based on workdays (8 hour/ 10 hour). By me dividing that by /8 or /10 accurately accomplishing that goal?

Thanks,

------------------------------
Alex Bennett
------------------------------
- AhuvaBrown
  Qrew Cadet
  5 years ago
  Can you provide sample data for the duration fields?
  
  ------------------------------
  Ahuva Brown
  ------------------------------
  - AlexBennett3
    Qrew Trainee
    5 years ago
    (ToText(Round([1. Sub Duration]/10, 0.01) & " " & "Days"))
    So far this is my only code that attempts to 'divide' to get result based on workdays (10hr / 8hr)
    
    ------------------------------
    Alex Bennett
    ------------------------------