I have a column [Correct Fees] populated by this statement:
=IF(OR(AND([@[Type of License Rcvd]]="new", [@[Fee Amount Collected]]=50), AND([@[Type of License Rcvd]]="renewal",[@[Fee Amount Collected]]=25)),"True","False")
However, when I try to use the COUNTIF statement:
=COUNTIF(Table1[Correct Fees], "True")/COUNTA(Table1[Correct Fees])
I just get a 0. Same goes for a simple COUNT of the column.
Aucun commentaire:
Enregistrer un commentaire