Total Revenue Formula

Question

Greetings.I have a small issue with a formula.The fields (indicated below) do not total if there is a null value in the the [Total Equipment Price] field.If you look at image file attached, they do not total left to right.I know this is probably a basic issue, but I just can't figure it out.Help is appreciated.Dirk[Total Labor Cost]+[Total Materials Price]+[Total Materials Mark-up]+[Total Sub Contractor Price]+[Total Sub Contractor Mark-up]+[Total Equipment Price]------------------------------Dirk Ruana------------------------------

stevedavidson · Answer

Hi Dirk,In all of those fields' settings, do you have the box checked that says "Treat blank values as 0 in calculations?"&nbsp;

------------------------------Steve------------------------------

dirkruana · Answer

Steve:That did the trick.&nbsp; Thank you so much! Dirk------------------------------Dirk Ruana------------------------------

Forum Discussion

Total Revenue Formula