I am trying to create a report showing sales revenues and COGS. If I create two separate reports - it works. But when I am trying to combine two together then only one calculates and the other shows $0 values (depending which one is added first). I am pulling information from the JrnlRow.Amount (sales) and then adding formula for COGS
If {JrnlRow.RowType} = 1 then
GetPeachRowAmountv2 (Filename, {JrnlRow.RowType}, {JrnlRow.Amount}, {JrnlRow.Journal}, {JrnlRow.PostOrder}, {JrnlRow.RowNumber}, {JrnlRow.RowDate}, {JrnlRow.ItemRecordNumber}).
Please advise how to fix this or what I am doing wrong.
If {JrnlRow.RowType} = 1 then
GetPeachRowAmountv2 (Filename, {JrnlRow.RowType}, {JrnlRow.Amount}, {JrnlRow.Journal}, {JrnlRow.PostOrder}, {JrnlRow.RowNumber}, {JrnlRow.RowDate}, {JrnlRow.ItemRecordNumber}).
Please advise how to fix this or what I am doing wrong.