Prompt Text Formula

[zsyed]

Wondering anyone could help me with this. I don't have any problem without condition but If I put If then Else condition then I'm getting syntax error.

Simple value: App.GetYear(Date(),"GL") - no problem with this input.

Conditional VAlue: (If App.GetPeriod(Date(),"GL")-1 = 0 Then App.GetYear(Date(),"GL")-1 else App.GetYear(Date(),"GL") end if) - Resulting Syntax error (1002).

Appreciate any help.

 

[kray4660]

I am assuming that you are using BASIC syntax in the formula editor, otherwise it should like this (If App.GetPeriod(Date(),"GL")-1 = 0 Then App.GetYear(Date(),"GL")-1 else App.GetYear(Date(),"GL"))

 

[zsyed]

I'm sorry I should have been more specific. This formula is being entered in Edit Parameter Field instance, in Prompt text field under value options. I tried with suggested syntax without end if, still I get error 1002.

 

[kray4660]

I have never tried to use a formula in here. Outside of my knowledge.