Skip to Content
avatar image
Former Member

Summary Field

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 20, 2015 at 08:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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