1 Reply Latest reply on Apr 23, 2019 7:12 AM by Bommi

    Formula column in report builder

    user615979

      Hi All,

       

        Working in R12 Version 12.1.3

       

      can i use parameter in formula column to filter the report

       

      option : yes/no /all

       

      like if i select No option then it should display only No and filter out yes and null entries

       

      please need some guidance

       

      function CF_COLLECTEDFORMULA0021 return Char is

      begin

          if :cf_balance_amt <> 0 (and  :P_collected = 'N' ) then

            return('No');

         elsif :cf_balance_amt <> 0 (and  :P_collected = 'Y' ) then

            return('Yes');

      else

      should display all

        end if;

      end;

       

      Regards