Formula

I use Parse shortcode before formula

Hi,

thanks for your question, and sorry for the trouble.

Did you also adjust the Shortcode of the table where it’s embedded? And do those gravitywp_count Shortcodes really return plain numbers?

Regards,
Tobias

Look https://bsoinsur.online/test2/

Hi,

the problem seems to be the , in the numbers. Due to this, the formula parser thinks that this is text ??

Regards,
Tobias

Thanks! I add to shortcode – thousands_sep=””
Works

Hi,

Great! ?? Good to hear that this helped!

Best wishes,
Tobias

P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Already)
And how to format the amounts below (formulas) with thousands?

Hi,

for that, you can use the NUMBER_FORMAT() function, see https://tablepress.org/tablepress-features-formulas/

Regards,
Tobias

Hi!
I use formula ={SUM(H2:H7)}
How to format this output?
number_format(={SUM(H2:H7)},2) don’t work

Hi,

the structure of the formula has to stay the same, of course:

=number_format(SUM(H2:H7),2)

Regards,
Tobias

Many thanks! It’s not entirely clear how to add spaces between thousands

Hi,

adding a space is not possible with this, I’m afraid. the NUMBER_FORMAT function can only add a comma as the thousand delimiter.

Regards,
Tobias

Why is it not possible to summarize a row, where the formula is of the type = number_format (SUM (I2: I8), 2) ? Error – https://bsoinsur.online/test2/

Hi,

same problem as above. You are trying to sum cells that contain a comma.

The trick here would be to add an extra hidden row. In that, you only use the formulas without number_format(), like just

=SUM(I2:I8)

(in cell I9).
Then, in the normal row (cell I10) you do the formatting of the calculated value:

=NUMBER_FORMAT(I9, 2)

Regards,
Tobias

Wow! Thanks!)