+ Start a Discussion
NehaaNehaa 

Formula field on reports

Hi,

 

I have created a formula field. I want  this field to be visible only in the reports but not on the page layout.

What do I need to do for this?

 

formula field= field1-field2.

 

if Field 1 is less than field 2--> it returns me negative number. I need only the difference but not negative symbol. what can i do for this?( ex: -11 but i need only 11)

 

Thanks

Kamatchi Devi SargunanathanKamatchi Devi Sargunanathan

Hi Nehaa,

 

To hide a formula field from the object, you can remove the field from the page layout of that object. Eventhough it is removed from pagelayout it can be used else where in Reports, Classes, Workflows and so on.

 

And to get the number value alone without its negative sign, you must write your formula like ABS(field1__c-field2__c)

 

Whenever you include ABS it will return the number without its sign.

 

If you feel this answer as your solution, Please mark this as a solution and give kudos by clicking on the star icon

NehaaNehaa
Thank you.
Kamatchi Devi SargunanathanKamatchi Devi Sargunanathan

Hi Nehaa,

 

Please mark my answer as a solution if it got works out.

 

Thank you.

sandeep@Salesforcesandeep@Salesforce

1. To get positive value all the time you can modfiy your formula and compare both fields before tsking difference.

2. Remove field from layout.

3. You need to keep include this formuls field on report layout ( you can refer report type layout for this)