Create a report for the Executive team || Challenge 6

Поделиться
HTML-код
  • Опубликовано: 30 окт 2024

Комментарии • 89

  • @paulovogado5550
    @paulovogado5550 14 дней назад

    That was heavy!!Thank you!!!

  • @asheesh857
    @asheesh857 Год назад +17

    Write this formula:
    IF(Account.Number_of_SolarBots__c:SUM>0, EXP_AMOUNT:SUM*1.1, EXP_AMOUNT:SUM)

  • @kiruthikasb1737
    @kiruthikasb1737 Год назад +5

    While validating formula... It shows " The report name can't be null".

    • @kiruthikasb1737
      @kiruthikasb1737 Год назад

      Are you getting validated?

    • @kiruthikasb1737
      @kiruthikasb1737 Год назад +2

      It u got, help me too to clear that

    • @AK-qr2su
      @AK-qr2su Год назад

      @@kpopmaeil were you able to solve the problem?

    • @AK-qr2su
      @AK-qr2su Год назад

      @@kiruthikasb1737 were you able to solve the problem?

    • @kiruthikasb1737
      @kiruthikasb1737 Год назад

      @@AK-qr2su not yet

  • @_Allaripilla_
    @_Allaripilla_ Год назад +3

    The settings for the 'Adjusted expected revenue' column aren't correct. Any solution for this error?

    • @Tentacipn69
      @Tentacipn69 Год назад

      Have you solved this one ? help mee to also

  • @__28__Alone
    @__28__Alone Год назад

    Add summary formula is disabled for me, what should i do?

  • @naminameesh7614
    @naminameesh7614 Год назад

    We can't find the updated organisation by state for the 'accounts without SolarBot Opportunities' report

  • @SAVITHAVIMALAN
    @SAVITHAVIMALAN 9 месяцев назад

    Challenge Not yet complete... here's what's wrong:
    We can’t find the correct fields on the 'SolarBot Loyalty Revenue' report, or data isn't organized by Stage.

  • @AK-qr2su
    @AK-qr2su Год назад +2

    i am getting this "The report name can't be null." error.who solved please be kind to share the solution.thanks!

  • @homemadelofi6308
    @homemadelofi6308 Год назад

    Thanks so much!!!

  • @TheEinstienBrothers.1010
    @TheEinstienBrothers.1010 Год назад

    It was showing error Report name can't be null

  • @arihantjain8998
    @arihantjain8998 2 года назад

    Thanku i hope today we complete full

  • @radhikarudnure2133
    @radhikarudnure2133 9 месяцев назад

    Challenge Not yet complete... here's what's wrong:
    We can’t find a new column 'Adjusted Expected Revenue' on the 'SolarBot Loyalty Revenue' report that meets the requirements. Can anyone solve this ?

    • @trailheadchallenge
      @trailheadchallenge  9 месяцев назад

      Hi @radhikarudnure
      Edit Solar Layalty Revenue Report
      Object: Opportunity
      Group Row: Stage
      Cloumns:
      Opportunity Name
      Account Name
      Type
      #Probability(%)
      # Ammount
      # Expected Revenue
      (keep the colunm sequnce as above)
      Create Summary Level Formula Column
      Column Name: Adjusted Expected Revenue
      Formula Output Type: Currency
      Decimal: 2
      In General section
      IF(Account.Number_of_SolarBots__c:SUM>0,EXP_AMOUNT:SUM*1.1,EXP_AMOUNY:SUM)
      click on Validate
      In Display Section
      Where should this formula be applied?
      select: Specific Groups
      select Stage
      Click on Apply

    • @radhikarudnure2133
      @radhikarudnure2133 9 месяцев назад

      But still I'm getting the same error

  • @SAVITHAVIMALAN
    @SAVITHAVIMALAN 9 месяцев назад

    Challenge Not yet complete... here's what's wrong:
    We can’t find the correct fields on the 'SolarBot Loyalty Revenue' report, or data isn't organized by Stage.
    pls help

    • @trailheadchallenge
      @trailheadchallenge  9 месяцев назад

      Edit Solar Layalty Revenue Report
      Object: Opportunity
      Group Row: Stage
      Cloumns:
      Opportunity Name
      Account Name
      Type
      #Probability(%)
      # Ammount
      # Expected Revenue
      (keep the colunm sequnce as above)
      Create Summary Level Formula Column
      Column Name: Adjusted Expected Revenue
      Formula Output Type: Currency
      Decimal: 2
      In General section
      IF(Account.Number_of_SolarBots__c:SUM>0,EXP_AMOUNT:SUM*1.1,EXP_AMOUNY:SUM)
      click on Validate
      In Display Section
      Where should this formula be applied?
      select: Specific Groups
      select Stage
      Click on Apply

  • @Abhishek-yb9kb
    @Abhishek-yb9kb 2 года назад

    Thanks for help. 😊😊

  • @diya1049
    @diya1049 Год назад

    trailhead@ Bro inexpected revenue column thre is no vaulesin my data plz tell mehow to slove this

  • @vitamin828
    @vitamin828 Год назад +2

    We can’t find a new column 'Adjusted Expected Revenue' on the 'SolarBot Loyalty Revenue' report that meets the requirements.
    Tearing my hair out over this one as I've done everything perfect but still

    • @trailheadchallenge
      @trailheadchallenge  Год назад +1

      Edit SolarBot Loyalty Revenue Report
      Under Outline: Columns
      Click on it
      Select Add Summary Formula
      Column Name : Adjusted Expected Revenue
      Formula Output Type : Currency
      Decimal Point: 2
      General
      IF(Account.Number_of_SolarBots__c:SUM>0,EXP_AMOUNT:SUM*1.1,EXP_AMOUNT:SUM)
      click on Validate
      click on Save
      if still u have any query u can read below article
      help.salesforce.com/s/articleView?id=sf.building_custom_summary_formulas.htm&language=en_US&type=5

    • @TheEinstienBrothers.1010
      @TheEinstienBrothers.1010 Год назад

      I was showing Report name can't be null in summary formula

  • @sreejanasahu9747
    @sreejanasahu9747 2 года назад

    we cannot find a new column adjusted excepted revenue on the solarbot loyalty revenue report that meets the requirements

    • @trailheadchallenge
      @trailheadchallenge  2 года назад +3

      Object Manager
      go to Opportunity
      go to Fields & Relationship->New
      Field Label Expected Revenue Data Type Currency(16, 2)
      Field Name ExpectedRevenue

    • @harshmishra4884
      @harshmishra4884 2 года назад

      ​@@trailheadchallenge still facing the same problem after executing this

    • @lalithapapolu9122
      @lalithapapolu9122 Год назад

      @@trailheadchallenge still facing the same problem

    • @syedgulshanara3768
      @syedgulshanara3768 Год назад

      @@trailheadchallenge It didn't clear again got same error pls help me here...

    • @24Driz
      @24Driz Год назад

      Ensure the new column is labeled correctly "Adjusted Expected Revenue" if that doesn't work follow these steps
      Object Manager
      go to Opportunity
      Field & Relationship -> New ->
      Field Label Expected Revenue Data Type Currency(16, 2)
      Field Name ExpectedRevenue

  • @parthopanigrahy4210
    @parthopanigrahy4210 2 года назад +1

    Where is challenge 2???

  • @PANKAJKUMAR-fe8zn
    @PANKAJKUMAR-fe8zn Год назад

    Thanks...my formula was wrong in summary-formula. now, I fixed it.

  • @nikhilsrivatsavapothukuchi8774
    @nikhilsrivatsavapothukuchi8774 2 года назад +1

    SIR AFTER COMPLETING THIS VIDEO I AM GETTING WE CANT FIND THE FOLDER FOR THE EXECUTIVE TEAM.PLEASE HELP ME SIR

  • @ramisettinarendra1096
    @ramisettinarendra1096 2 года назад

    Ante akada mistake ani ardhm kavadam ladhu bro.. Plzz tell me

  • @pollasyrole1
    @pollasyrole1 Год назад

    thanks, i had same error over n over.

  • @gonthinachiranjeevi3448
    @gonthinachiranjeevi3448 Год назад

    The formula for the 'Adjusted Expected Revenue' column doest meet the business reguirements please hlep out this sir..

    • @nagalakshmipulusu6375
      @nagalakshmipulusu6375 Год назад

      Complete ayyindha ee error plz help me

    • @lalithapapolu9122
      @lalithapapolu9122 Год назад

      @@nagalakshmipulusu6375 same error for me could uh plz help me

    • @trailheadchallenge
      @trailheadchallenge  9 месяцев назад

      Edit Solar Layalty Revenue Report
      Object: Opportunity
      Group Row: Stage
      Cloumns:
      Opportunity Name
      Account Name
      Type
      #Probability(%)
      # Ammount
      # Expected Revenue
      (keep the colunm sequnce as above)
      Create Summary Level Formula Column
      Column Name: Adjusted Expected Revenue
      Formula Output Type: Currency
      Decimal: 2
      In General section
      IF(Account.Number_of_SolarBots__c:SUM>0,EXP_AMOUNT:SUM*1.1,EXP_AMOUNY:SUM)
      click on Validate
      In Display Section
      Where should this formula be applied?
      select: Specific Groups
      select Stage
      Click on Apply

  • @sreejanasahu9747
    @sreejanasahu9747 2 года назад

    this is error what we have to do

  • @HhGg-hd7pr
    @HhGg-hd7pr 2 года назад

    In challenge 5 it getting error any one please help me
    We can't find the categorization called temperature range or the categorization is based on an incorrect field, or the category setting are incorrect on the temperature to keh research report

    • @trailheadchallenge
      @trailheadchallenge  Год назад

      trailhead.salesforce.com/trailblazer-community/feed/0D54S00000A8diDSAR

  • @KkKk-vr1is
    @KkKk-vr1is 2 года назад

    Where is challenge 2

  • @ramisettinarendra1096
    @ramisettinarendra1096 2 года назад

    The settings for the adjusted expected revenue column aren't corret means

    • @akshaysheela7843
      @akshaysheela7843 Год назад

      Check the syntax of the formula or change the output type to currency

    • @Tentacipn69
      @Tentacipn69 Год назад

      @@akshaysheela7843 Tried with this but it shows same Error , Any other suggestions?

  • @kick__world
    @kick__world 2 года назад

    @trailhead challenge

  • @sreejanasahu9747
    @sreejanasahu9747 2 года назад

    iam getting same after solved sir your commment sir

    • @trailheadchallenge
      @trailheadchallenge  Год назад

      IF(Account.Number_of_SolarBots__c:SUM>0,EXP_AMOUNT:SUM*1.1,EXP_AMOUNT:SUM)

  • @Mekathotipriyankapriyanka
    @Mekathotipriyankapriyanka Год назад

    please help me i have error challenge not yet complete data is not recognised by stage

  • @shaikshavali3810
    @shaikshavali3810 2 года назад

    The formula for the 'Adjusted Expected Revenue' column doesn't meet the business requirements

    • @vinnu438
      @vinnu438 2 года назад

      Same py

    • @arb07gaming67
      @arb07gaming67 2 года назад

      Same problem can u get sol for this

    • @HhGg-hd7pr
      @HhGg-hd7pr 2 года назад

      @@arb07gaming67 bro neku challenge 5 complete aiyinda

    • @syedgulshanara3768
      @syedgulshanara3768 Год назад

      Have you cleared this?pls help me with the solution

    • @trailheadchallenge
      @trailheadchallenge  Год назад

      IF(Account.Number_of_SolarBots__c:SUM>0,EXP_AMOUNT:SUM*1.1,EXP_AMOUNT:SUM)

  • @jayavardhanvardhan8559
    @jayavardhanvardhan8559 2 года назад

    Please upload the formula

    • @akshaysheela7843
      @akshaysheela7843 Год назад

      @Desire Good IF(Account.Number_of_SolarBots__c:SUM>=1, EXP_AMOUNT:SUM*1.10, EXP_AMOUNT:SUM)

    • @generationsimple8413
      @generationsimple8413 Год назад

      @Desire Good No Sir, I followed Akshay formula and it was right.

    • @trailheadchallenge
      @trailheadchallenge  Год назад

      IF(Account.Number_of_SolarBots__c:SUM>0,EXP_AMOUNT:SUM*1.1,EXP_AMOUNT:SUM)

  • @kick__world
    @kick__world 2 года назад

    @trailblazer Syntax error.missing')' problem

    • @psn116
      @psn116 2 года назад +1

      Put comma after SUM>0 in the edit summery level formula

    • @kasirajasekhararao8123
      @kasirajasekhararao8123 Год назад

      @@psn116 But my error is not solved.

    • @kasirajasekhararao8123
      @kasirajasekhararao8123 Год назад

      I have put the symbol '_' wherever required and it worked for me!

    • @kasirajasekhararao8123
      @kasirajasekhararao8123 Год назад

      @Desire Good Type the symbol instead of space. It worked for me but I can't ensure to everyone.

    • @trailheadchallenge
      @trailheadchallenge  9 месяцев назад

      Edit Solar Layalty Revenue Report
      Object: Opportunity
      Group Row: Stage
      Cloumns:
      Opportunity Name
      Account Name
      Type
      #Probability(%)
      # Ammount
      # Expected Revenue
      (keep the colunm sequnce as above)
      Create Summary Level Formula Column
      Column Name: Adjusted Expected Revenue
      Formula Output Type: Currency
      Decimal: 2
      In General section
      IF(Account.Number_of_SolarBots__c:SUM>0,EXP_AMOUNT:SUM*1.1,EXP_AMOUNY:SUM)
      click on Validate
      In Display Section
      Where should this formula be applied?
      select: Specific Groups
      select Stage
      Click on Apply