variables

[Jamal]

Hi  friends,

I have this variable in the script : LET vCurrentYear = num(year(today()));

and this variable in variable overview : =If(getpossiblecount ([year])=1, [year], max([year])).

when i reload the document, this function [If(getpossiblecount ([year])=1, [year], max([year]))] is gone .

Could  you please help me.

[Somasundaram · Accepted solution]

Hi,

Hope you don;t have separate column name as 'Year'. 

you are calculating year from today(). Use as a separate column for getpossiblecount() function.

[anushree1 · Accepted solution]

Thats because Script Variable definition is overwriting the Variable definition in the Variable Overview section,please rename the variable in one of the sections and check

[Jamal]

Thank you very much