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

Popular Salesforce Videos

Salesforce Integration Tutorial | Integrate Salesforce with Apps

Video in

This "𝐒𝐚𝐥𝐞𝐬𝐟𝐨𝐫𝐜𝐞 𝐈𝐧𝐭𝐞𝐠𝐫𝐚𝐭𝐢𝐨𝐧 𝐓𝐮𝐭𝐨𝐫𝐢𝐚𝐥" video by Edureka will help you understand what is Salesforce integration in detail. It will also address the various Salesforce integration…