Percentage - divide one field by another

Oh, absolutely! Just remarking on the trend for in-memory calculation, which I guess is a symptom of RAM prices coming down considerably.

1 Like

hi all

how to write (this year sales-last year sales/Last year sales) in Mongo

Regards
Jayanthan

Hi maz,

I have a question about this. I’ve created a joined table of ‘views’ and ‘uses’ of which I’ve calculated the amount of views and uses in the last month, which are 20k and 5k respectiviley. by dividing uses by views, in a self made collumn, i am supposed to get a ratio of about .25 which is my conversion.

However, when i do this the answer is 0, also when i click the decimal number up. I’ve had this before with a more complicated SQL, and thought it was my fault, but it keeps on happening. would you by any chance know why this could be the case…