I need a formula that references an empty field to not display as zero.
I need a formula that references an empty field to not display as zero.
Here is a bigger picture of what I've got going on to hopefully clarify what i'm looking for. I have parts checkout table that has a table to table relationship with a master parts list table. I've made multiple reports from this mast part list table where each "Item" has a report to list multiple serial numbers under that Item calcification.
When the user is going to check out a part in the parts check out table, they select a radio button for a part type and then a drop down list will source serial numbers from one of the previously built reports. For example, by selecting "Related Item 1", "Related Item 2",or "Related Item 3" a different list of serial numbers would show available. For each transaction, only one item / serial number is able to be selected. So if i choose Item 2 and pick a serial number from that filed, then Item 1 and Item 3 would be blank.
I have report in the check out table that is a mast list of all the check outs. Instead of seeing "Related Item 1", "Related Item 2", and "Related Item 3" columns on the report where two of the three columns would be blank, i want to make a field that would combine all of these related item into one formula text field to display a serial number regardless which Related Item is selected. I've tried a few options but the empty fields keep displaying zeros. Can i please get some of your expertise on combining these fields without having the empty spaces display as zeros?
Here is a bigger picture of what I've got going on to hopefully clarify what i'm looking for. I have parts checkout table that has a table to table relationship with a master parts list table. I've made multiple reports from this mast part list table where each "Item" has a report to list multiple serial numbers under that Item calcification.
When the user is going to check out a part in the parts check out table, they select a radio button for a part type and then a drop down list will source serial numbers from one of the previously built reports. For example, by selecting "Related Item 1", "Related Item 2",or "Related Item 3" a different list of serial numbers would show available. For each transaction, only one item / serial number is able to be selected. So if i choose Item 2 and pick a serial number from that filed, then Item 1 and Item 3 would be blank.
I have report in the check out table that is a mast list of all the check outs. Instead of seeing "Related Item 1", "Related Item 2", and "Related Item 3" columns on the report where two of the three columns would be blank, i want to make a field that would combine all of these related item into one formula text field to display a serial number regardless which Related Item is selected. I've tried a few options but the empty fields keep displaying zeros. Can i please get some of your expertise on combining these fields without having the empty spaces display as zeros?
