Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My requirement is by default the year = current year and period = current period.
I have created two trigger actions.One for Year and the other one for Period.
Year is working but not period.Can anyone help me on this.
=only({<PeriodID={"$(=max(PeriodID))"}>} [Calendar Period])
Hi,
Do you have possibility to upload a sample?
Please attached a sample.
The issue is probably due to a date format, do you use select in Field Period, max(Period)?
Would making a single concatenated field of Year & Period help ?
What is "period" and how the action looks like?
Is your period field related to year?
If so, be carefull about your expression on second action
Hi All,
Here is the attached sample file.Thanks in advance.
Try =MAXSTRING([Calendar Period])
MAXSTRING([Calendar Period]) is not working.
Cast you Calendar Period in a dual :
Dual(
IF (FISCAL_PERIOD = 1,'P1',
IF (FISCAL_PERIOD=2,'P2',
IF (FISCAL_PERIOD = 3, 'P3',
IF (FISCAL_PERIOD = 4,'P4',
IF (FISCAL_PERIOD = 5,'P5',
IF (FISCAL_PERIOD = 6,'P6',
IF (FISCAL_PERIOD = 7,'P7',
IF (FISCAL_PERIOD = 8,'P8',
IF (FISCAL_PERIOD = 9,'P9',
IF (FISCAL_PERIOD = 10,'P10',
IF (FISCAL_PERIOD = 11,'P11',
IF (FISCAL_PERIOD = 12,'P12',
IF (FISCAL_PERIOD = 13, 'P13'))))))))))))), ((FISCAL_YEAR-1)*13) +FISCAL_PERIOD) AS 'Calendar Period'
then using Max([Calendar Period]) in a select in Field action should do the trick.