Skip to main content
Topics#Reports & DashboardsMayur Tripathi의 질문
Mayur Tripathi (NA) 님이 #Reports & Dashboards에 질문했습니다
2017년 11월 15일 오전 7: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개
  1. Mayur Tripathi (NA)
    2017년 11월 22일 오후 6: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
답변을 작성하세요...
0/9000