3 Replies Latest reply: Sep 2, 2014 5:41 AM by PAUL YEO RSS

    How to convert table to chart ?

    PAUL YEO

      Hi All

       

      In my previous post , the information i give is not so clear , so i try to post again :-

       

      I need to plot the Table A 2 value 2,579,737 and 563,620 at chart A.

       

      So my chart will display 2 bar , one bar = 2,579,737 another bar will display 563,620

       

      Hope some one can advise me.

       

       

      Paul

          • Re: How to convert table to chart ?
            Manish Kachhia

            Create a bar chart...

            DIMENSION

            NO DIMENSION

             

            EXPRESSIONS

             

            NUM(SUM(IF(CURRENCY='EUR',TOTAL*1.64,

            IF(CURRENCY='NT',TOTAL/24,

            IF(CURRENCY='USD',TOTAL*1.25,

            IF(CURRENCY='YEN',TOTAL*0.012,

            IF(CURRENCY='SGD',TOTAL*1))

            )))),'#,##0')

             

             

             

            NUM(SUM(

            IF(CURRENCY='EUR',DAY30*1.64,

            IF(CURRENCY='NT',DAY30/24,

            IF(CURRENCY='USD',DAY30*1.25,

            IF(CURRENCY='YEN',DAY30*0.012,

            IF(CURRENCY='SGD',DAY30*1))

            )))),'#,##0')

              • Re: How to convert table to chart ?
                PAUL YEO

                Hi Manish

                 

                Your proposal work fine.

                 

                NUM(SUM(IF(US_Cust='EU',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1.64,

                IF(US_Cust='NT',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))/24,

                IF(US_Cust='USD',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1.25,

                IF(US_Cust='YEN',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*0.012,

                IF(US_Cust='SGD',(sum(days3) + sum(days6) + sum(days9) + sum(above12)+sum(curren))*1))

                )))),'#,##0')

                 

                But i have another table , with out provide me the total amount , i try above expression , it reutrn null value. any advise ?