If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

prompt macro not rendering for 2nd case statement Help..

Started by maxchuie, 06 May 2017 06:16:17 PM

Previous topic - Next topic

maxchuie

10.2.2 fp2
Please I need help.. this statement works for the 1st part (1) but when i select 2 in my prompt it still gives me the results for (1)

case when  #prompt('TopXOption','integer',1)# = 1
  then
   (case when ([Rank Adjusted Risk Factors (Provider)] <= #prompt('TopX','integer',100)#) then
   ([Rank Adjusted Risk Factors (Provider)])
   else 0
   end
   )
when #prompt('TopXOption','integer',2)# = 2
     then
   (case when ([Rank Risk Factors (Provider)] <= #prompt('TopX','integer',100)#) then
   ([Rank Risk Factors (Provider)]) 
else 0  end
    )
else  (0) end

thx

AnalyticsWithJay

I see this is a few days old... Do you still need help on this?