Script

[evansabres]

I have a field called [Ticket Base Price] that has various values, however, I specifically want to call out when this field has a value of 0.00.

I want to do this in my script so as to be able to use this in my application.

Currently, I tried to do this:

IF([Ticket Base Price]='0.00', 'COMP',)

AS

Grouping,

However this does not pull in any data.

Any suggestions on what I am doing wrong or how to better approach this?

[krishnacbe · Accepted solution]

Hi,

Try below expression. Remove the Comma after the string.

If([Ticket Base Price]='0.00','COMP') as Grouping

[evansabres]

This returns no value. The structure allows me to reload the data, however when I look at the table preview, there is no value.

[evansabres]

I made a small error when I entered your suggestion. You were correct, thank you.