• #42774
    Forcetalks

    Can we create a Formula Type in Reports in Salesforce?

    Can we create a Formula Type in Reports in Salesforce?

    #44373
    Forcetalks

    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.
Viewing 2 posts - 1 through 2 (of 2 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2019 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?