Question (or Enhancement?): how to use 'regular expression' to calculate a relation between columns

GoldenGnu / jeveassets

jEveAssets is an out-of-game asset manager for Eve-Online, written in Java

http://eve.nikr.net/jeveasset

GNU General Public License v2.0

147 stars 36 forks source link

Question (or Enhancement?): how to use 'regular expression' to calculate a relation between columns #419

Closed aixtools closed 2 months ago

aixtools commented 9 months ago

An example:

Sometimes a max buy price is 1.00 (because noone is seriously buying - hoping for an unattentive seller) - while the lowest sell price is - for simplicity - 100.00 - a 100% spread.

I would like to be able to calculate the ratio/difference between two columns (e.g., minSell/maxBuy) (and maybe add *100(%) to convert to %).

So question: how to do this using regular expression - if possible.

If not possible, please consider as an enhancement.

GoldenGnu commented 9 months ago

I also think this could be done using a formula column. 1) Table > Formula Columns > Add 2) Select a name 3) Formula [Sell Min] / [Buy Max] * 100

Does that resolve the issue for you?

GoldenGnu commented 2 months ago

I'm going to close this as resolved, as a solution have been presented and there is no reply from the user.

Feel free to comment on this issue, if you want it re-opened.