Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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
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.
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