function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
vamsi@sfvamsi@sf 

How to add custom filtering criteria to reports of tabular format

1)

I want to filter the records based on some basic arithmatic operations on values of particular columns.

 

Eg; i would like to show the record in report only if its particular numerical field is of say 'n' digit or even number ...

How can i add it as filter for tabular format.

I know it supports some filter logic like AND , OR operations on existing filters.

 

But my requirement is different.

 

2)

 

How to show the difference of values of 2 columns a record in report in another column.. I want this column to be added for all records in report.

One way is to create a formula field (field 1 - field 2) in the object of record and add it as column in report.

But i want this column to be added in report itself with out the aid of any formula field in object

Is there any way out???

 

Thanks

bob_buzzardbob_buzzard
You can't add custom formulas to a tabular report - you'll have to have a summary report to do that.  Your only option is to add a formula field to the record to provide the information.