Could you please attach sample data as twbx or excel + clear expectation with example numbers.
Yes, so I am trying to divide MANUAL COUNT by TOTAL TRANSACTIONS to get the % of transactions which are manual.
MANUAL COUNT: COUNTD(IF [Manual Positive] = 1 then [Vendor Invoice Id] else null end)
TOTAL TRANSACTIONS: COUNTD(IF [Invoice Status]= 'MATCHED' or [Invoice Status]='INTERFACED' THEN [Vendor Invoice Id] else NULL end)
When I create a new Calculation: Manual Count / Total Transactions I get zero.