Hello All,
I have this query Union below. I would like to add a prompt for year and period. But I need some help creating an expression that will replace the period value with "beginning balance" on all periods that precede the selected prompt value for period. For instance, if I select period 8 on the prompt, period 0 - 7 will be replaced with "beginning balance". Thanks for your help
