Forum Discussion

MarkGlevicky's avatar
MarkGlevicky
Qrew Cadet
6 years ago

Formula for a report - text triggers number

I have a column in a report that I want to put a report formula column next to.  The initial column contains text and I want the formula column to put a numeric value based on the text in the first column.  Here's what I've come up with but it doesn't like something here.  Hope you can help.

If ([WRO] contains "W", .5, null )
If ([WRO] contains "R", 1, null )

5 Replies