I have a reprot I am having trouble creating:
- I need to try and use Opportunity splits to caculate the split from a custom field on opportunity
- This field is "Total Booking Value" which caulates a total based on contract length
- This field does show in teh opportunit splits report however, splitting it to try and make it show correctly on the dashbaord is proving to be troublesome.
- Essentially I have this custom field which calculates a curreny value. In a report to split this I need to use a formula a summary report to split, which is "Opportunity.Total_Booking_Value__c:SUM *SPLIT_PERCENTAGE:SUM and that works however, the field wont seems to sum and I need to get these figures per user to show ona dashbaord in a list view. When adding at all summary levels I get a figure which is summed but is much lasrger than it shoudl be/is.
Has anyone had any experience with this or can help in any way?
Many thanks..
(PS, I might have another questions coming in a bit!)
1 answer
Hi Alastair,
Do you have any negative value in the "Total_Booking_Value_c" field.?
Regards,
Dhananjey.
