Skip to main content
Topics#Reports & DashboardsQuestion de Mayur Tripathi
Mayur Tripathi (NA) a posé une question dans #Reports & Dashboards
15 nov. 2017, 07:07

Contracts Net Sales report

Got stuck with a requirement where i have to add a column (Net Sales/Change) in a report by taking another column Contract type (New+Renewel-Cancellation) which is a multi picklist, the problem is when i am trying to put formula in the report,the Contract type is not showing in the dropdown. It is kind of very urgent, if someone coud help would be very grateful.

 

----------------------------------------------------------------------------------------------------------------------

 

Configuration Changes: Need to add calculated field or value to show Net Sales/Change

 

[(New Contracts) + Renewal Contracts)] – (Cancellations) = Net Sales/Change

 

Required Data: 

 

Contract Type = New

 

Sum of ‘Total Contract Values’

 

+

 

Contract Type = Renewal

 

Sum of ‘Total Contract Value’

 

-

 

Contract Type = Cancellation

 

Sum of ‘Value of Cancellation’

 

-----------------------------------------------------------------------------------------------------------
2 réponses
  1. Mayur Tripathi (NA)
    22 nov. 2017, 18:20
    Hi Jeff, could you please be more specific on this , as if we can not create formula on pcklist then how can we achieve this, actuall my bad , Net Sales is not any column, this just client wants below the name of Report, attaching the screenshot for this as well.

     

    Hi Jeff, could you please be more specific on this , as if we can not create formula on pcklist then how can we achieve this, actuall my bad , Net Sales is not any column, this just client wants below
Rédiger une réponse...
0/9000