Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
You have to use it like this:
=if(IsNull($(varmod)),(MonthStart(Peek('massimo',0,'c'),+1))),($(varmod)))
I think this will work.
Best,
Sunny
You have to use it like this:
=if(IsNull($(varmod)),(MonthStart(Peek('massimo',0,'c'),+1))),($(varmod)))
I think this will work.
Best,
Sunny
thanks!! it works!!
I am glad that it worked.
Best,
Sunny