on 11-12-2007 8:31 PM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, what are the steps for that?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you tried putting it into a User Data store and then referencing it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.