cancel
Showing results for 
Search instead for 
Did you mean: 

Check if values are 0.00

Former Member
0 Kudos

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,

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

No, what are the steps for that?

Former Member
0 Kudos

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