All Ideas

Idea Details

Post an Idea
This idea has been delivered and can no longer be voted or commented on. If you’d like to add to this conversation, please post a new idea.
610  Points voting closed
Delivered in Summer '12
Idea is generally available.

Formula Field Cross Report Type - Joined Reports

Reports & Dashboards

Would like to be able to create formula field between summarized totalizations of different Report Types. The new feature Joined Reports allow you to put the total amount of two different reports types together in the report, but don´t allow to make formulas between it. 

Follow the example: I have two different objects to register orders. One of them are order from Brazil and the other are order form USA. Would like to have the total amount of invoices in my Company.

User-added image


· Flag

Latest Comment from Salesforce

  • Thomas Tobin - 6 years ago

    I have a question about the names.
    Currently, this feature uses something called "Cross-block Custom Summary Formula"
    However, that good name provides a problem for us - what to call Custom Summary Formulas that aren't like this one and calculating across the blocks

    The features as built for summer is a way of generating Custom Summary Formulas in Joined Reports such that you can name which block a field's value should be taken from. That means you can have a block of won deals, and a block of lost deals, and then calculate the win ratio by saying 
    [won deals]Amount:sum/([won deals]Amount:sum+[lost deals]amount:sum)
    and that has the name "Cross-Block Custom Summary Formula". And we think that's a pretty good and descriptive name. You could put that xCSF in either block, it would give the same answers. 

    But that means we have the other kind of CSF - the one that was in Spring'12. That one doesn't let you specify a block, and so will only calculate locally in a single block for fields from a single report type. If you had the other kind, and say "amount:sum*2" then it would show different amounts in the won and lost blocks.
    What should we call that one?
  • Upvotes
  • Downvotes



from AppExchange


Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.