5 Replies Latest reply on Sep 26, 2016 1:35 PM by Thomas Dodds

    Count formula in percentage calculations

    Aluros

      Hi!

       

      I am wondering how to create a numeric Count variable in Oracle BI.

      For instance, I have one string column that contains different types of invoices (X or Y or Z). Is it possible to count how many types of X invoices I have? I would like to find percentage of X-type invoices in total amount of invoices (X+Y+Z), how can I do it in case of having string variable? Error code

      What I have tried so far is formula CASE WHEN in order to replace X-type invoices with 1 and everything else with 0. However, it is not possible to find SUM of these "dummy" variables