Supercharge Your Reports in Summer '19 with Row-Level Formulas

Поділитися
Вставка
  • Опубліковано 26 лип 2024
  • 🧐Did you know that you can write row-level formulas for your Salesforce reports? Row level calculations in your reports means you don't have to create a new custom formula field or export to excel to perform specific calculations when you need them! Once you have created your row level formula, you can sort on this formula within your report.
    Note: As of the Winter '20 release, this feature is GA and does not require the setup step of enabling this feature. Learn moar in the Winter '20 release notes: releasenotes.docs.salesforce....
    Learn more here: admin.salesforce.com/get-buil...
  • Навчання та стиль

КОМЕНТАРІ • 18

  • @patrickj.trevenen1633
    @patrickj.trevenen1633 5 років тому

    Great Video

  • @david57989
    @david57989 Рік тому

    Powerful!

  • @mariosuarez5195
    @mariosuarez5195 3 роки тому +4

    2021 and we're still stuck with only one row level formula per report.

  • @felipebenavides9750
    @felipebenavides9750 3 роки тому +1

    For the Emoji's Keyboard in Windows, you press the windows key + the period button (dot)

  • @NYCWatcher1
    @NYCWatcher1 3 роки тому

    What if you have more than 2 conditions? Say closed date conditions =50. What would you put into the formula field?
    IF ((close_date -today()), value1, value2, value3... value if false)...
    How would I achieve the above formula? Thanks.

  • @grantculp4820
    @grantculp4820 4 роки тому +2

    Can you create Multiple Row Level Formulas, on the same report?

  • @MarkCrimper
    @MarkCrimper 3 роки тому

    Winter 21' this setting is not showing. Where can I find this setting? I went exactly where you said.

  • @ankursoni3400
    @ankursoni3400 Рік тому

    I need to add a column of the count of rows in front of all the rows in that group. The same total count should be in front of all the rows. Is it possible?

  • @dcl140
    @dcl140 5 років тому +1

    Did this feature roll out to all orgs? mine doesn't have this option under Report and Dashboards Settings?

    • @SalesforceAdmins
      @SalesforceAdmins  5 років тому

      Hi DC, This feature was rolled out to org in Lightning Experience with the last release, I would check this documentation and make sure you have all the appropriate perms: help.salesforce.com/articleView?id=reports_formulas_row_level_limits.htm&type=5 -LeeAnne

    • @Related-minds
      @Related-minds 5 років тому

      same

  • @violetlim6785
    @violetlim6785 Рік тому

    Is there away to change the output type into %

  • @janeisaac
    @janeisaac 5 років тому +2

    Can you filter on ow level formulas?

    • @SalesforceAdmins
      @SalesforceAdmins  5 років тому

      Hi Jane! You cannot currently filter on row level formulas. This is a beta feature in Summer '19, you can view this and other limitations here: help.salesforce.com/articleView?id=reports_formulas_row_level_limits.htm&type=5 -LeeAnne

  • @andybecker8196
    @andybecker8196 5 років тому +1

    How do you get the emoji window to pop up?

    • @CannonCornelia
      @CannonCornelia 4 роки тому

      I would like to know how to get it to pop up using Windows 10 as well.

    • @derrickchavez3595
      @derrickchavez3595 4 роки тому

      @@CannonCornelia same here. let me know if you find out. im searching the internet. not sure if you have to enable something or not.

  • @Jmoneypoprocks
    @Jmoneypoprocks 3 роки тому

    so clunky!