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%