- Original Poster
- #1
Hi, I'm trying to redesign the ICHASETERMS1 letter so that it includes unallocated payments and outstanding credit notes, regardless of their date. I've changed the criteria of the report so that it shows it but I need to change it to a negative value.
Currently the Expression is this:
Due > 0 ? AUDIT_SPLIT.DATE_FLAG <> 1 ? SignedAgedTransaction : 0 : 0
but I want to amend it so that if AUDIT_HEADER.TYPE is "SC" or SA" then SignedAgedTransaction needs to turn negative. I'm good with Excel but knowledge of those formula seem to be of no help here!!
Tried for a long time now, no luck!
Any help much appreciated
Thanks!
Currently the Expression is this:
Due > 0 ? AUDIT_SPLIT.DATE_FLAG <> 1 ? SignedAgedTransaction : 0 : 0
but I want to amend it so that if AUDIT_HEADER.TYPE is "SC" or SA" then SignedAgedTransaction needs to turn negative. I'm good with Excel but knowledge of those formula seem to be of no help here!!
Tried for a long time now, no luck!
Any help much appreciated
Thanks!
