How to modify an existing formula in Gupta

Legacy Contributor

Hello,
I am trying to modify an existing formula in one of our qrp forms that is selecting one of three warehouses to produce the shipping delivery report. I would like to add a second warehouse to the formula so that the report will show shipments from either warehouse. The current formula looks like this...

NumberIFF( StrCompare( PRIMARY_WHS_ID , 'WHS' ) , 0 , 1 , 0 )

WHS is the current warehouse being selected. I would like add in, MN as another warehouse to be included into the report.

I have tried a couple of times with commas and things but I don't know programming.

Please just tell me how to insert "MN" into this formula so that both WHS and MN will be included.

Thank you,
Paul

Legacy Contributor

If you're using the NumberIFF( StrCompare( PRIMARY_WHS_ID , 'WHS' ) , 0 , 1 , 0 ) formula to conditionally display a line, then NumberIFF( StrCompare( PRIMARY_WHS_ID , 'WHS' ) , 1 , 1 , 0 ) should show warehouse 'MN', or any warehouse <

'WHS'





if used in the Properties: Line/Conditional Display section, NumberIFF( StrCompare( PRIMARY_WHS_ID , 'WHS' ) , 0 , 1 , 0 ) would hide any line where the warehouse <> 'WHS'.



If you only want WHS or MN, you'll have to nest your NumberIFF and StrCompare formulas.