Double variable

[Anonymous]

Good morning to everybody,

I have a variable ( MonthStart(Peek('massimo',0,'c'),+1)) that makes a reduction in the loaded table.

Now i need to creation of a new variable (varmod) that change the value of previous variable, like this way:

          if(IsNull($varmod),(MonthStart(Peek('massimo',0,'c'),+1))),($varmod))

The problem is that in the process of loading, ($varmod) is not seen as a variable, but as a field, which implies an error because can not find the field ($varmod).

[sunny_talwar · Accepted solution]

You have to use it like this:

=if(IsNull($(varmod)),(MonthStart(Peek('massimo',0,'c'),+1))),($(varmod)))

I think this will work.

Best,

Sunny

[Anonymous]

thanks!! it works!!

[sunny_talwar]

I am glad that it worked.

Best,

Sunny