• Resolved Nitrat

    (@nitrat)


    Hello
    In the cells b8, b9, b10 i use the shortcodes:
    b8 = [gravitywp_count formid=7 number_field=88 start_date=”08/01/2017″ end_date=”08/31/2017″]
    b9 = [gravitywp_count formid=7 number_field=88 start_date=”09/01/2017″ end_date=”09/30/2017″]
    и 10 = [gravitywp_count formid=7 number_field=88 start_date=”10/01/2017″ end_date=”10/31/2017″]
    In b14 this sum formula don’t work –
    ={SUM(B8:B10)}
    !ERROR! B8 does not contain a number or expression

Viewing 4 replies - 16 through 19 (of 19 total)
  • Thread Starter Nitrat

    (@nitrat)

    And why export to Excel does not include lines with formulas?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    I’m not sure what you mean. Which export to Excel do you mean?

    Regards,
    Tobias

    Thread Starter Nitrat

    (@nitrat)

    With TablePress DataTables Buttons Extension

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    this will only export the result data, because it doesn’t know that formulas are used in the background (on the server).

    If you want to export it with formulas, you have to do that on the “Export” screen in the admin area, and choose CSV as the format.

    Regards,
    Tobias

Viewing 4 replies - 16 through 19 (of 19 total)
  • The topic ‘Formula’ is closed to new replies.