Activity Forums Salesforce® Discussions Can we create a Formula Type in Salesforce Reports?

  • chanchal kumar

    Member
    October 8, 2018 at 2:36 PM

    Hi,

    Add a Summary Formula Column in Lightning Experience:

    • Edit or create a report.
    • If necessary, group report data. From the Groups section, select a field from the Add group... lookup menu under GROUP ROWS.
    • From the Columns section, click   | Add Summary Formula Column.
    • Optionally, to open the full editor, click Switch to Full Editor.
    • Enter a summary formula. For example: IF(AMOUNT:SUM < 1000000, AMOUNT:SUM * (1 - 0.15), AMOUNT:SUM * (1 - 0.20))
    • To see if your formula contains errors, click Check Syntax. Resolve any errors.
    • Optionally, click FORMAT to choose how to format results, how many decimals points to show, and to change
    • where the formula gets applied.
    • Click Apply.
    • Click Save.

Log In to reply.

Popular Salesforce Blogs

AI in Salesforce

Transform businesses with the power of Artificial Intelligence leveraged through Salesforce Einstein

Blog in

Artificial Intelligence is powering next-generation customer experiences with smart predictions, intelligent recommendations, timely automation and much more. Gartner predicts that by 2020, a staggering 85% of…

Popular Salesforce Videos