Issue with CELLGETN returning numeric values

wzsycdh

Hi Friends,

I am facing an issue. I am retrieving a value using CELLGETN function and assigning it to a variable as shown below.

nRevAdjPctVal = CellgetN (sCube, V10, V1, 'REV ADJ PCT', 'LoadStat-All', 'BP-All', 'BOXMES-All', 'FOP-All', 'Sector-All', 'AP-All', V8, 'data');

Now when I am comparing the value for nRevAdjPctVal in the If statement,

If ( nRevAdjPctVal <>= 0 );

I am getting an error that says, "Incorrect Logical Comparison".

Can Anybody help me as to why it is happening?

Thanks in advance

西山红叶

Suharsh wrote:Hi Friends,

I am facing an issue. I am retrieving a value using CELLGETN function and assigning it to a variable as shown below.

nRevAdjPctVal = CellgetN (sCube, V10, V1, 'REV ADJ PCT', 'LoadStat-All', 'BP-All', 'BOXMES-All', 'FOP-All', 'Sector-All', 'AP-All', V8, 'data');

Now when I am comparing the value for nRevAdjPctVal in the If statement,  

If ( nRevAdjPctVal <>= 0 );

I am getting an error that says, "Incorrect Logical Comparison".

Can Anybody help me as to why it is happening?

Thanks in advance

What do you mean by "<>="? If you want not equal to, use "<>".

jhh6yf

Hi asutcliffe,

Thanks for the suggestion. It was a small error which got rectified. Actually I was going through one of the other reputed TM1 forum and someone there suggested to use ~ and <>= operators.

Thanks for the help anyways.