By using this website, you agree to our Terms of Use (click here)
I am creating a GI to export out data that will eventually become a journal entry. The format of the journal entry requires the addition of a blank column in the GI. Is it possible to do this?
You can add any column with a value and instead of showing that value add a =IFF() condition. i.e. =IIf( [table.field]<>NULL, ' ', ' ' )
Used the following =IIf( [POReceipt.ReceiptType]<>NULL, ' ', ' ' ) and the column disappeared from the output.
it could be on a different name like the name of the formula. is it also marked as visible?
I like IsNull() as a function.
=IIf( IsNull([POReceipt.ReceiptType], '') = '', ' ', ' ' )
It replaces the value with the second parameter if null. In this case a null with an empty string.
Would this have worked without a field at all? I seem to remember doing this.
=''
Online Members
