How can i create a YTD Advanced Function?
Hi - i want to easily calculate a year to date (YTD) function in my reports. Is there a way to create my own 'Advanced Function' (as distinct from a 'calculated field')?
i want my function to return the aggregate of all amounts where the transaction date is less than x date and greater than or equal to 1 July of corresponding financial year.
can you please provide instructions on how i could achieve this