topic Re: Issue with a variable not working in App Development

Issue with a variable not working

Anonymous — Thu, 25 Jan 2018 15:28:27 GMT

Hi all,

I have this expression that is working exactly as I want while it is in a text box. However, when I define the expression as a variable it stops working! Do you have any idea why?

=if(GetFieldSelections(OrdItemInsDt)>0,

(if(GetFieldSelections(OrdItemInsDt)<7,

date(min(OrdItemInsDt))& ' to ' & date(max(OrdItemInsDt)),

(if(Left(GetFieldSelections(OrdItemInsDt),3) = '',

max({<Year-={$(=SubField(GetFieldSelections(OrdItemInsDt),'',2))}>} OrdItemInsDt),

date(min(OrdItemInsDt)))& ' to ' & if(Left(GetFieldSelections(OrdItemInsDt),3) = '',

max({<Year-={$(=SubField(GetFieldSelections(OrdItemInsDt),'',2))}>} OrdItemInsDt),

date(max(OrdItemInsDt)))))),

$(vLastInsDtWeek))

Thank You!

Re: Issue with a variable not working

kuczynska — Thu, 25 Jan 2018 15:43:09 GMT

Hi,

It could be an issue around using "=" in the variable definition window and using/not using the $ expansion in your expression window. Could you confirm how you are initiating the expression?

thanks,

Micha

Re: Issue with a variable not working

Anonymous — Thu, 25 Jan 2018 15:56:09 GMT

Thank you Micha!

It was because of the "=" in the variable definition... I thought we should always use it but I was wrong...

Thank you very much for you help!

Sofia