IF statement help

[itguymike]

i have the statement below that is giving me a total amount of days a product has left until it is past it's expiration day.
works great for all locations that are labeled short dated, here is the question, is also puts a '0' for the days left to exp on other location for example Quarantine locations. how can i have it just show me the days till exp on only locations that are Shortdated?

IF {PART_LOCATION.LOCATION_ID}='SHORTDATED' THEN {TRACE.EXPIRATION_DATE}-CURRENTDATE

thanks

 

[briangriffin]

If I'm understanding you correctly, you are displaying the records that you want but just don't want the 0 to display on products that are not shortdated.

Right click on your formula and select Format Field, then go to the Common tab. Click the X2 next to Suppress - here is where you put the logic for the ones you want to suppress, which should be:

{PART_LOCATION.LOCATION_ID} <> 'SHORTDATED'