Can we implement a calculation option within the chart an a grand total at the end?

  • Profile Image
    weingutbuehler
    Asked on November 26, 2014 at 08:16 AM
    By chance - is there a possibility that you can implement a calculation option within the chart an a grand total at the end? In this specific request:
    Equation: Row 2 x Row 3 = Row 4
    All results of Row 4 = Grand total
    Thank you very much for your help!
    Holger
  • Profile Image
    EltonCris
    Answered on November 26, 2014 at 10:15 AM

    Hi Holger,

    I think this widget will help. http://widgets.jotform.com/widget/spreadsheet

    Just like normal spreadsheets, you can create formula to calculate the rows and a formula to get the grand total.

    Hope this helps. If you need further assistance, let us know.

    Regards!

  • Profile Image
    adminweinguthuelsde
    Answered on November 26, 2014 at 10:44 AM

    Dear EltonCris!

    Thank you for your reply. Somehow I don't get the calculation form to work. Row D should display the result of multiplication of row B and C: Can you help.

    I'm not good at CSS coding - can you also help to determine how to change the size of the rows and how to change their color?
    Is it possible to change the header row names, e.g. "A" to "Product number"?

     

    Thank you so much for your help!

    Holger 

  • Profile Image
    EltonCris
    Answered on November 26, 2014 at 11:50 AM

    There are samples on the widget description which you can try. I have just tried it and it's working fine.

    Header letters (e.g. A, B, C) are default and can't be changed just like spreadsheet. However you can add text values on the first row as your headers.

    Example with formula D = B*C

    A1 First Header
    B1 Second Header
    C1 Third Header
    D1 Grand Total
    D2  = B2*C2
    D3  = B3*C3

    Screenshot:

    With regards to the CSS codes, I have move it to a separated thread. We'll assist you with that once we get there.

    Thanks!