Happy Business Starts Here

Re: Ability to compare data source fields to each other in filter clauses

Ability to compare data source fields to each other in filter clauses

Currently, Export ZOQL and the report builder's UI only let's me compare a data source fields to a literal value. Sometimes I need to compare field values to determine whether I want to include a record in a report or export. The only other option is to add a custom field and some custom code, which is not always reasonable.

2 Comments
Zuora Alumni
Status changed to: Under Consideration
 
Valued Scholar

I'm trying to do exactly this. I get around it by exporting to excel and doing a quick formula but it would be better if I could do it in reports.

One example I'm currently looking at is a report where I want to see where the subscription owner and invoice owner don't match. I do a report on subscription data source and pull out the following fields then export to excel to look for differences. 

  • Subscription: Creator Account ID
  • Subscription: Invoice Owner ID 

(obviously if there's a better way to do this would love to hear it)