Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Re: Status of Invoice


FileMakin' Tom

Recommended Posts

Have "yesses" = 0 in another calc field. Any other answer = 1. Sum the field and then if the sum = 0, the invoice is complete. if 1 or more, it is not. Do not store.

 

Case(Field = "Yes",

0,

1

)

 

Tom laugh.gif

Link to comment
Share on other sites

Oh! Forgot. Last calc field would determine the answer based on the summary field.

 

Case(IsEmpty(SummaryField) or Summary field

"Complete",

"Incomplete"

)

 

Tom laugh.gif

Link to comment
Share on other sites

Tom,

 

I also like that method laugh.gif . You may remember suggesting this to me a while back and it does work like charm wink.gif . Thanks again!

 

Michael

Link to comment
Share on other sites



×
×
  • Create New...

Important Information

Terms of Use