Questions tagged [report-formula]
The report-formula tag has no usage guidance.
0
votes
1answer
28 views
Formula that uses IF statements not working
I am trying to use a formula field on the Campaign Member object to pull from either a Lead or Contact. The Formula Text field works but the Formula Number field does not, and I am not sure why.
So ...
0
votes
1answer
12 views
Creating a Report Formula
Trying to divide the sum of one grouping of Amount by Grand Total Amount, example:
Record type: New Biz
Amount 100
Amount 200
Sum = 300
Record type: Existing Biz
Amount 50
Amount 200
Sum = 250
Grand ...
0
votes
0answers
72 views
PARENTGROUPVAL formula not working as expected?
I have an object called Incoming Numbers, which has a lookup 'Incoming Number Prefix', I want to find the number of numbers by % assigned to each Incoming Number prefix... Here is a screenshot of what ...
0
votes
1answer
191 views
Report Formula - print number based on picklist value
I have problems creating a report formula. I would like to express the following:
IF(ISPICKVAL(Status_Picklist__c, 'green'), 100, 20)
I have a picklist Status_Picklist__c and if that picklist is set ...
0
votes
1answer
1k views
How to subtract months from a date field
How to subtract months from a date field:
I have a date field on opportunity, called: Current Term End date.
I want to create a Formula field, which will subtract 3 month from Current Term End date ...
