If Formula for Null values
I am using a formula to calculate "Total Contract Value" for our clients. This is what I have so far. The problem is, where the Invoice Duration field is null, my formulas are not calculating anyt...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIs the [Invoice Duration] field set to treat blank as zero in field properties? If so uncheck that setting.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Brilliant! This worked. Thanks, Mark!
Jen
------------------------------
Jen Black
------------------------------
