1 Reply Latest reply: Mar 7, 2016 7:57 AM by m w RSS

    Help with expressions

    Keith Jones

      Hi there

       

      I have created the below expressions to access the values in my data and both work great.

       

       

      =sum({<tablename = {'Own Funds'}, x= {'c0020'}, y={'R0500'}>} num(value,'#,##0'))  /* (A) */

      =sum({<tablename = {'Own Funds'}, x= {'c0020'}, y={'R0580'}>} num(value,'#,##0'))  /*  (B) */

       

      I am struggling to create the expression  A / B *100 to obtain a percentage.

       

      Its probably very easy but I dont have much experience and have been unable to find a solution.

       

      Thanks for your anticipated help.

       

      Keith