You need to sign in to do that
Don't have an account?
CHANDRA KANTH KONDURU 10
Need help with Formula Field creation
Hi All,
The below mentioned fields are to be created in PROJECT(Custom Object)
OBJECT DATA TYPE VALUE
1. Total Certified Number Equal to number of WON Opportunities associated with this project
2.Total Leads Generated Look up (Number) Equal to number of Leads. Can be calculated by adding up all the leads generated by the campaigns under this project.
3.Total Actual Balance Currency (Formula) Total Actual Balance equals budget minus expenses for all completed Campaigns
4.Total Projected Closing Balance / Currency (Formula) Total Projected Closing Balance equals Total Actual Balance minus all expenses for ongoing or future Campaigns
5.Total Delta Currency (Formula) Total Delta is equal to Total Projected Closing Balance minus budget. (Total Delta can be a positive or negative number)
6.Total Allocated Resources Number Equal to the total number of Users who are owners of a campaign or a campaign task under this project.
Can anyone please help me with this.
Thanks,
Chandu
The below mentioned fields are to be created in PROJECT(Custom Object)
OBJECT DATA TYPE VALUE
1. Total Certified Number Equal to number of WON Opportunities associated with this project
2.Total Leads Generated Look up (Number) Equal to number of Leads. Can be calculated by adding up all the leads generated by the campaigns under this project.
3.Total Actual Balance Currency (Formula) Total Actual Balance equals budget minus expenses for all completed Campaigns
4.Total Projected Closing Balance / Currency (Formula) Total Projected Closing Balance equals Total Actual Balance minus all expenses for ongoing or future Campaigns
5.Total Delta Currency (Formula) Total Delta is equal to Total Projected Closing Balance minus budget. (Total Delta can be a positive or negative number)
6.Total Allocated Resources Number Equal to the total number of Users who are owners of a campaign or a campaign task under this project.
Can anyone please help me with this.
Thanks,
Chandu
Do you need any other details.
- Tells us if you have tried to write a formula and give us the formula text ( we can help you but cannot train you )
- What is the type of relationship between Project and Campaigns, also tells us the parent
Thanks,Venkat