Hi All,
I want to setup a calculated field in explore that takes a package quantity UDF and divides the on-hand quantity by that to show the number of cases they have on hand. The hitch is that not all of the items have a pack size and some items have zero on hand. This is easy in Crystal but I can't figure out how to make is display zero if the on-hand is zero.
Anyone have any ideas on this?