0 Replies Latest reply: Jun 9, 2012 9:27 PM by 922971 RSS

    Issue in passing multiple values to a presentation variable in 11.1.1.5.0

    922971
      Hi Experts,

      I have requirement where I want to calculate a %age of codes in a set of codes ( means let's say I have selected 10 codes(1 to 10) in that I want to calculate %age of 1st, 2nd code eg: total 10 codes count =1000 and code1 count =100 and code2 count =90 then the calculation should be %age= ((100+90)/1000) * 100=19%.
      procedure code is a dimension column and it is varchar.

      And here, I want to give a user to pick the set of codes (Numerator(Nr), Denominator(Dr)) as a prompt in the dashboard, for that I created a 2 presentation variables (proc,proctotal) for Nr, Dr as prompts and passing that to the column formula where I created using that variables.

      Nr formula: (sum(cast(case when"Procedure"."Procedure Code" IN('@{proc}') then 1 else 0 end as double)))

      Dr formula: (sum(cast(case when"Procedure"."Procedure Code" IN('@{proctotal}') then 1 else 0 end as double)))

      third column

      100*(sum(cast(case when"Procedure"."Procedure Code" IN('@{proc}') then 1 else 0 end as double)))/(sum(cast(case when"Procedure"."Procedure Code" IN('@{proctotal}') then 1 else 0 end as double)))

      If I enter only one code(Nr, Dr) in prompts i am getting results, if I enter multiple codes giving results as zero's

      can someone please put some inputs , or another approach, really appreciate your answers.

      Thanks
      KP

      Edited by: 919968 on Jun 9, 2012 7:27 PM