09-12-2016 11:48 AM - edited 09-12-2016 12:16 PM
I have uploaded a table to SAS LASR server. The table has the below data.
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)
However, I don't get the value 150 in the Calculated data item, but get 0. Can some one help ?
09-21-2016 05:03 PM
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