cancel
Showing results for 
Search instead for 
Did you mean: 

Summary Field

Former Member
0 Kudos

I have a summary (field) set up to show the minimum number but I need to add a condition to to show the minimum number excluding (0.00), have a good evening.

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi,

Try this please:

1) Create a formula with this code:

if isnull({database_field}) OR {database_field} = 0 then 99999999

else {database_field}

2) Insert a summary with the minimum function on this formula field,

-Abhilash

Former Member
0 Kudos

I'm saving the formula but for some reason got up this morning and did not have that isse, thanks again  have a good day

Answers (0)