SAS Visual Analytics - Data

[KrisNori]

Hi,

I have uploaded a table to SAS LASR server. The table has the below data.

Month      Value

Jan          1000

Feb          1500

.........................

Dec          2000

I wanted to work on a particular month's data (say, Feb)

I created a calculated data item (Feb_Val) as below:

IF (RemoveBlanks('Month'n, _All_) = 'Feb')

RETURN ('Value'n * 0.1)

ELSE 0

However, I don't get the value 150 in the Calculated data item, but get 0. Can some one help ?

[ShannonMoore]

KrisNori, I just tested this in VA 7.3 Designer and it worked fine for me. I created a LASR table by importing a small excel file and then created the calculated item using your formula. What does the table look like in VA for you? My screen shot shows the new item and the values to the left.  Shannon