<@UPQ5F2MMW> it's really unclear what you are aski...
# generalm
michoel
10/31/2019, 5:26 AM@dane it's really unclear what you are asking. Please give more details, and even better screenshots of your criteria and results
d
dane
10/31/2019, 5:30 AMLISTAGG(Decode({accounttype}, 'accountspayable','',{amount}),'<br>')
This is my formula.
and the result is:
dane
10/31/2019, 5:31 AMmessage has been deleted
dane
10/31/2019, 5:31 AM@michoel
m
michoel
10/31/2019, 5:34 AMWhat are you trying to achieve?
d
dane
10/31/2019, 5:39 AMI want to display the amount per item per bill with many items but the other bill who had one item, the amount is duplicating.
a
Alex Hirota
10/31/2019, 5:51 AM@dane It looks like your function is printing the Total Amount for the entire Bill first, and then breaking down the price by item.
Alex Hirota
10/31/2019, 5:52 AMSo technically it’s working, though I imagine you don’t want the total amount.
m
michoel
10/31/2019, 6:10 AMYou could add a filter for Main Line = No to your search, unless you need the main line
michoel
10/31/2019, 6:12 AMOtherwise you could probably change the DECODE in the formula to a CASE and check
mainlineaccounttype