Shortcodes before formulas

  • Resolved miamihoosier

    (@miamihoosier)


    7 years, 9 months ago

    I have data in a table table id=4 Ten numbers in a column which I add and then divide by 10 for the average.. {Sum(C2:C11)/10} Works great and displays properly. I want to use the average number in another table. I am using Single cell content and parse shortcode before forumlas. When I use [table-cell id=4 cell=D12] is returns the forumla, not the number. When I use: [shortcodes_before_formulas=true table-cell id=4 cell=D12 /] it returns exactly that message. I’m sorry I’m not an advanced programmer, but thanks for any help in how I can display the numerical content of cell D12 in my other table 4 instead of the forumla. Thanks again! I tried this in my final table: [table id=topten datatables_counter_column=true shortcodes_before_formulas=true /] It returns: !ERROR! Circle Reference

    • This topic was modified 7 years, 9 months ago by miamihoosier.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 9 months ago

    Hi,

    thanks for your question, and sorry for the trouble.

    I’m afraid that this will not directly work like this. The Single Cell Shortcode Extension can only retrieve the raw data, but no calculated values.

    You will therefore have to move the calculation of the average to the other table. This then means that you will have to use a full formula there, where the Single Cell Shortcode Extension is used inside the formula:

    =([table-cell id=4 cell=C2 /]+[table-cell id=4 cell=C3 /]+[table-cell id=4 cell=C4 /]+[table-cell id=4 cell=C5 /]+[table-cell id=4 cell=C6 /]+[table-cell id=4 cell=C7 /]+[table-cell id=4 cell=C8 /]+[table-cell id=4 cell=C9 /]+[table-cell id=4 cell=C10 /]+[table-cell id=4 cell=C11 /])/10

    (Using SUM() is not possible, because of the necessary range support.)

    Regards,
    Tobias

    Thread Starter miamihoosier

    (@miamihoosier)

    7 years, 9 months ago

    Thanks so much for your reply. I really appreciate you responding to small issues like this. I under what you are saying. I’ll approach this from the direction you suggested. Thanks again so much!

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    7 years, 9 months ago

    Hi,

    great! Good to hear that this suggestion will help!

    Best wishes,
    Tobias

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Shortcodes before formulas’ is closed to new replies.