Discussions

Expand all | Collapse all

Formula for a report - text triggers number

  • 1.  Formula for a report - text triggers number

    Posted 03-21-2019 13:22
    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 )


  • 2.  RE: Formula for a report - text triggers number

    Posted 03-21-2019 13:34
    This is how you write a Contains() statement for your situation: 

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




  • 3.  RE: Formula for a report - text triggers number

    Posted 03-21-2019 13:42
    Or shorter...

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


  • 4.  RE: Formula for a report - text triggers number

    Posted 03-21-2019 15:38
    THANK YOU!  Mark


  • 5.  RE: Formula for a report - text triggers number

    Posted 03-21-2019 15:47
    ... and Laura.


  • 6.  RE: Formula for a report - text triggers number

    Posted 03-21-2019 16:14
    I was signing my name  :)  But thank you Laura as well!