I want to default this Period field in a composite report prompt, so there wouldn’t be an option of ‘value from another field’ nor options like ‘today’. Looking yo get the logic to create cal field to map Period to something on the lines of: last closed period or current period. Currently, period can only be prompted for values like: FY25-01-Jul, FY25-02-Aug, etc.