Skip to main content
Topics#Reports & DashboardsPergunta de Saranya Kumar
Saranya Kumar (Cognizant Technology Solutions) perguntou em #Reports & Dashboards
13 de mai. de 2021, 10:19

Solution to Parentgroup Value for a report

Hi,

 

I'm trying to build a formula with Parentgroup value for report. But I end with incorrect one!!

 

I'm not able to get the percentage of shipped quantity. below formula is the one i'm looking to build in reports. Not able to get correct syntax

 

Percentage%=

 

  (Sum ofShipped quantity CY2021 - Sum of Shipped Quantity CY2020)/(Shipped quantity CY2020).

 

Please find the attached report screenshot with report and grouping.

 

Percentage should be for each rebate group and not for orderstartdate

 

Solution to Parentgroup Value for a reportUser-added image

 

Any help on this would be appreciated!!

 

Thanks in Advance!!

 

Regards,

 

Saranya K 
3 respostas
  1. Steve Molis (You Owe Me a Beer, Inc.)
    13 de mai. de 2021, 12:58
    Are you looking for something kind of like this? 

     

    Are you looking for something kind of like this? These are the 4 Formulas that I usedFormula 1 (Variance Count)Opportunity.Opportunity__c:SUM - PREVGROUPVAL(Opportunity.

     

    These are the 4 Formulas that I used

    Formula 1 (Variance Count)
    Opportunity.Opportunity__c:SUM - PREVGROUPVAL(Opportunity.Opportunity__c:SUM, CLOSE_DATE)
    Formula 2(Variance %)
    IF(PREVGROUPVAL(Opportunity.Opportunity__c:SUM, CLOSE_DATE) <> 0,
    (Opportunity.Opportunity__c:SUM - PREVGROUPVAL(Opportunity.Opportunity__c:SUM, CLOSE_DATE)) /  PREVGROUPVAL(Opportunity.Opportunity__c:SUM, CLOSE_DATE),NULL)
    Formula 3 (Variance $Amount)
    AMOUNT:SUM - PREVGROUPVAL(AMOUNT:SUM, CLOSE_DATE)
    Formula 4 ($Variance %)
    IF(PREVGROUPVAL(AMOUNT:SUM, CLOSE_DATE) <> 0,
    (AMOUNT:SUM - PREVGROUPVAL(AMOUNT:SUM, CLOSE_DATE)) /  PREVGROUPVAL(AMOUNT:SUM, CLOSE_DATE),NULL )

     

     
Escrever uma resposta...
0/9000