Sage 100

Does anyone know if it is possible to do if/then expressions in Business Insights? I am trying to create some aging buckets and have the following to calculate the age if the invoice (as a numeric field): {fn CURRENT_DATE()} - (""AR_OpenInvoice"".""InvoiceDate""). If it is possible then I can show if it falls in the range or show 0 if it doesn't. -OR- I can create another calculated field that shows the buckets based on greater than less than... something like: ({fn CURRENT_DATE()}-(""AR_OpenInvoice"".""InvoiceDate"") < 120) but I get an error, so suggestions on how to make that work would be welcome as well :)

You can calculate the age of an invoice using {fn CURRENT_DATE()}-""AR_OpenInvoice"".""InvoiceDate"" as the calculation. I don't think you can do conditional calculations but you could filter on the aging date calculated above and only get items in the aging bucket you are looking at.