rrenee
rrenee
Reactions
-
Re: Count(Distinct Formula Help
Hi @JMartinez73, If you want to find a count of the distinct company ID's that have their project canceled, I would use the COUNTIFS formula instead: =COUNTIFS(DISTINCT({CompanyID}), <>"&q…1 · -
Re: Conditional Logic on Forms
Hi, Given the fields I could see in your screenshots, I made two new Reports simply labeled "Other" that in theory do want to see the Month/QTR, Review Period and Case Types. With this logi…1 · -
Re: formula
I wrote a formula that essentially says if Paid in full is not checked, subtract the original invoice amount and the second invoice amount from the job total. You could adjust this to only subtract t…1 ·
