Formula in trigger

[#1]

Hi

I would like to make a trigger on the action "open"

I have a field called Fiscal Period that goes from 1-12, when the year is over. Now I have 1 and 2.

Then I would like to say that when the report is opened, then it should open with filter on MAX (Fiscal Period) = 2, but I can not get it to work. If I type in 2, then it works.

Any help here? I have tried the formula MAX, MAXstring, NUMmax..

Best regards

Bjarne

[Anonymous · Accepted solution]

Bjarne,

Based on your description, I'd say that this should work:

=max("Fiscal Period")

If not, something's missing in your description, and you need to upload a sample application.

Regards,

Michael

[#3]

Dohh

I did not use the "=" sign. That was it. Thanks