fwtrader

Hi,
I am confused after the answer from the moderator.
I didn’t do anything different with my new question from 2 days ago than I did when asking other questions. I never received any emails with answers from other forum visitors, so I do now from Sunday. What have I done wrong? Why is it then?
I have just unsubscribed, as you suggested, but what is the effect? Can I no longer post new questions in this forum about this plugin or other plugins? I don’t understand or is it a bug in the forum software?

Fred

Hi Tobias,

since I asked a new question about rounding in two numbers last Sunday, I keep getting an email from all new questions and your answers, very difficult.
I have till now from last sunday received 31 emails. I can’t figure out how to turn that off.
I just put a check at the bottom (as with my other questions): notify me or follow up by mail. But that check mark is on this topic. So why do I receive all emails concerning questions and answers from others? And it only concerns the Tablepress forum and it only started on Sunday evening, 2 days ago.
You gave me a link, but it won’t get me any further.

I have now unchecked the box below, maybe this will give a result, but I now no longer receive a message about this subject, so I no longer see my mailbox, that makes it difficult.
Regards,

Fred

Hi Tobias,
thanks for the answer, I know about the math calculations page, but I’m going wrong there. I really have no idea how to apply it, I tried everything yesterday, but what I’m missing is a clear example of how to apply a formula.
I have given you this as an example:
= {AVERAGE (B4: B12)}
I’ve tried all of this
= number_format (x, 2) {AVERAGE (B4: B12)}
or
= {AVERAGE (B4: B12) number_format_eu (x, 2)}
or
= round (x, 2) {AVERAGE (B4: B12)}
or
= {AVERAGE (B4: B12) round (x, 2)}

But no matter what I try, I keep getting an error.
Can you give me the formula which I should use?

And another problem, since yesterday I keep getting every question that is asked by others on the forum and every answer by e-mail, so something goes wrong.

thanks,

Fred

Hello Tobias,

I apologize, but I don’t understand any of this.
I understand that what I would like is not possible or that I first have to adjust the php codes in the backend?

Given my age (65+) that won’t happen, I have no knowledge of that. Too bad, maybe this is a suggestion to take with you for a future expansion?

Kind thanks for your help, greetings, Fred

Tobias,

when I use your formula
={number_format_eu( if( F7>0.0, sum(B7/F7), 0.0 ), 2 )} %

I get this error:

!ERROR! illegal character ‘&’ %

Fred

Thanks again Tobias,

I changed it all with your new formula
={number_format_eu( sum(B2/F2), 2 )} %

so this is the conclusion:
when I hide the rows wit INF it seems to work correctly,
but when I made the rows containing INF visible then the sorting is wrong again.

So without the INF the sorting now with the new formula is perfect, but when the result in a cel comes with INF then the sorting is false.
Now, what to do?
I need a good sorting and I need ofcourse all de rows.
But what if a cell comes with result INF? In stead of INF can you make a formula where the result INF is shown as 0,00
Is that possible in all the cells in that row?

Fred.

Tobias, I am so sorry, I see I am wrong with the above question.

Please look to my site https://www.beleggenmetplezier.nl/performance/

I have expanded my table with a column “koers winst verhouding”
with this formula (where column F2 is hidden)

={round( sum(B2/F2),2)} %

As you can see, the column price is filled with a good result, and as desired with a maximum of 2 digits after the comma.
But you see my problem, the result in one cell is somrtimes 1 digit before the comma and 2 after the comma, in another cell 2 digits before the comma etc.

But if you now sort the column from high to low, or low to high the cells who are with 1 digit before the comma comes between the cells with 2 digits before the comma, that is of course not correct.

How can that be solved?

Many thanks for your answer, greetings, Fred

• This reply was modified 6 years ago by fwtrader.

Great Tobias, thanks, now its working, its seems good.