Formula for a report - text triggers number

Question

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 )

laurathacker · Answer

This is how you write a Contains() statement for your situation:&nbsp;If(Contains([WRO],"W"),5,If(Contains([WRO],"R"),1,null))

quickbasecoachd · Answer

Or shorter...  If(  Contains([WRO],"W"),5,  Contains([WRO],"R"),1)

markglevicky · Answer

THANK YOU!&nbsp; Mark

quickbasecoachd · Answer

... and Laura.

markglevicky · Answer

I was signing my name&nbsp; :)&nbsp; But thank you Laura as well!

Forum Discussion

Formula for a report - text triggers number

Related Content

Pipeline Not Triggering

Merging 2 Fields into a Formula-Text Field for Reporting Purposes

Pipeline trigger(s) based on formula field changes

Formula Url Buttons

Summary Reports