My goal is to have a report splitted by custom segment values (in this case, to have one column for each result), I tried with a report but I think is not possible, with a financial report I have this possibility to get the segment values by columns, but cannot use the fields from AR aging report.
I am trying to create a saved search based in this article: https://suiteanswers.custhelp.com/app/answers/detail/a_id/1011618/loc/en_US
I am customizing the formula to add my requisition: {line.custseg1} = 'Dec 2022'. However the result is getting me either 0, or not the correct one.
This is my formula so far, I just added my condition and deleted dates and other statements:
Case
When {line.cseg1} = 'Dec 2022' AND substr({amount},1,1)= '-' then ({amountremaining}*-1)
When {line.cseg1} = 'Dec 2022' AND substr({amount},1,1) <> '-' then {amountremaining}
else 0 end
Any ideas why it is not working?