Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Add static values to a filtered data item in SAS VA

Reply
Frequent Learner
Posts: 1

Add static values to a filtered data item in SAS VA

Hi,

 

I'm trying to add a static value to a data item by creating a new calculated measure. The problem I'm having is that there is a filter and I want a different number to be added for different filter values. Currently, I'm doing this :

 

IF ( 'report_brand'n = 'ABC' )
RETURN ( 'Number YTD LY (#)'n + 123456 )
ELSE (
IF ( 'report_brand'n = 'XYZ' )
RETURN ( 'Number YTD LY (#)'n + 654321 )
ELSE 'Number YTD LY (#)'n )

 

123456 and 654321 are the numbers I wanna add to 'Number YTD LY (#)' on the basis of report_brand chosen in filter. Currenlty it looks as if it is adding the number to the total value of 'Number YTD LY (#)' and not to the 'Number YTD LY (#)' for the chosen report_brand. 

Post a Question
Discussion Stats
  • 0 replies
  • 161 views
  • 0 likes
  • 1 in conversation