Hi there,

Im struggling to count a value in my database. Essentially I want to look up a value (field called "Profit/Loss) and then count how many times the value in that field is greater then / smaller than 0, then apply math to this output to determine win/loss percent.

Example of database

Field 1 = $50

Field 2 = -$10

Field 3 = 100

Value greater then 0 should equal 2

Value smaller then 0 should equal 1

Then apply this math to determine Win percent

(2/3)x100 = 66.67%