Hi, how do you compare a count of transactions vs a numeric field? Ex. SO has billing transactions (invoices) and custom field for the number of invoices is expected to be made. i could not use the COUNT Summary since I could not compare with a nunber from a another field. Any tips? Thanks

You can do this, but it only works in non-summary mode and doesn't work if you've filtered for mainline = true:

COUNT/*sql*/(DISTINCT {billingtransaction.id}) OVER (PARTITION BY {internalid})

You can wrap this all in a CASE WHEN statement to compare it to your custom field