Percentages

[bknight]

I'm trying to calculate percentages of profitable and unprofitable trades, but I get an error in the first expressions.

Code: Select all

PosPerc: Count([Profit]>0)/count(not null([profit]))

and

Code: Select all

 NegPerc: Count([Profit]>0)/count(not null([profit]))

I get an error invalid syntax. I know there will have to be a multiply by 100 somewhere in the expression.

[HansV]

Try

PosPerc: Sum([Profit]>0)/Sum([Profit] Is Not Null)

and set the Format property of the PosPerc column to Percent.

[bknight]

That worked, thanks