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

    Help with expressions

      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.