Skip to Content
author's profile photo
Former Member

Crystal Select Expert with formulas

Hi,

I have developed a Crystal Report in Version 2013. I have all the data in a Group Header as had to subtotal ID number of employees.

In Select Expert I can't find the formula to rid the employees who have a 0 total can I do this another way???

Thank you.

Yvonne

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Sep 04, 2014 at 02:23 AM

    Hi Abhilash,

    It is a formula in a formula. I used an if, then else function with the formula for the previous field subtracting the measured field.

    eg. If {@formula} > {measure.field} then 0

    else {measure.field} - {@formula}

    The formulas works great but I need to suppress the employees who have a total of 0 so we can only see the employee's with a figure.

    Thank you so much for your help!

    Yvonne

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 02, 2014 at 04:20 AM

    Hi Yvonne,

    You can't do that from the Record Selection Formula.

    Go to Report > Selection Formulas > Group and and use this code:

    Sum({measure field}, {group field}) > 0

    Replace {measure field} with the numeric field and {group field} with the field you've used as the group.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 02, 2014 at 04:41 AM

    Hi Abhilash,

    Thank you for the formula however when I try this it come up with the message cannot summarize this field and highlights the {measure field}.

    Do you know why this would be?

    Yvonne

    Add comment
    10|10000 characters needed characters exceeded