If Statement in Table builder

Jet Reports Historic Posts

May 03, 2013 18:31

None

I am new to jet and cannot figure out how to create an If statement in the table builder. This is what I tried using the "create formula" option. =If[@[Prom. Ship Date]]=[@[Ship Date]],[@[Invoiced Qty.]],0

Thanks!

Teri

Date Votes

2 comments

Jet Reports Historic Posts May 03, 2013 20:43 Official comment

Hi Teri,

Your IF formula needs to be a regular Excel formula, so you need parenthesis like this:

=IF([@[Prom. Ship Date]]=[@[Ship Date]],[@[Invoiced Qty.]],0)
Does that help?

Regards,
Hughes

Comment actions Permalink
0

Jet Reports Historic Posts May 06, 2013 15:55

Hughes,

If statement worked perfectly.

Thanks!

Teri

Comment actions Permalink

Please sign in to leave a comment.