Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I try to make the amount of document type "Credit Memo & Payment" by and the other type by
I use this expression:
if(wildmatch([Document_Type06],'*Credit Memo*','*Payment*'),-1*[Amount06],[Amount06])
but it give me null values!
Hi,
Try this.
Sum(if(wildmatch([Document_Type06],'*Credit Memo*','*Payment*'),-1*[Amount06],[Amount06]))
Regards,
Kaushik Solanki
I think you need an aggregation for your amounts, like sum([Amount06])
- Marcus
Hi,
Try this.
Sum(if(wildmatch([Document_Type06],'*Credit Memo*','*Payment*'),-1*[Amount06],[Amount06]))
Regards,
Kaushik Solanki