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
I see this is a few days old... Do you still need help on this?