By using this website, you agree to our Terms of Use (click here)
I have a very basic question. I'm still learning how to write financial reports. I'd like to run a 2023 P&L with YTD total through whatever period I enter in the report parameters:
My Column Set is hardcoded for the 12 months of 2023, using the start and end periods and turnover as the amount type. I selected "Suppress Empty" and "Hide Zero" in each column.
I've entered my rents and monthly expenses through June of 2023. So, whenever I try to run my P&L using any end date, in runs through June no matter which financial period I enter in the report parameters. In my report definition, I selected "REQUEST" in the End Period, but it ignores it:
I appreciate any help. Thank you!!
As long as there is data in the period, it will print, unless you use the Visible Formula line in the Column Set to suppress it.
You could try something like this for January, then replace <=1 with <=2 for February, etc.
=IIf(Left(@StartPeriod,2)>=1, true, false)