To retrieve the Male with status as NEW use the below calc and name the calc as Male New Order Number
IF Gender = "Male" and status="New"
To retrieve the Female with status as NEW use the below calc and name the calc as Female New Order Number
IF Gender = "Female" and status="New"
Now you have two calculated fields you can do the division calculation since you didnt mention aggregation of Order i am assuming as countd
(COUNTD(Female New Order Number)/COUNTD(ale New Order Number))-1
This will do
Hope this helps. Plz mark this answer as correct or helpful to close the thread