Skip to Content
avatar image
Former Member

Check if values are 0.00

I need to check if the field X in the query is 0.00. If so, then display "HELLO" in the table field Y.

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 12, 2007 at 09:00 PM

    Have you tried putting it into a User Data store and then referencing it?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 12, 2007 at 09:25 PM

    No, what are the steps for that?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 12, 2007 at 10:42 PM

    Kevin,

    you could add an additional field to the output port of the query (for table field Y), and calculate its value dynamically by using the formula -->if(@x == 0.0, 'Hello','Others')

    prachi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 14, 2007 at 09:19 AM

    If you use a table for displaying your query data use an expression box with a formula and reference to the field X and hide the field X and display instead the expression box.

    Best Regards,

    Marcel

    Add comment
    10|10000 characters needed characters exceeded