I would like to use the following formula in a calculated field in a query:
CorrCN: Max(0,(([S1_Raw-CN]-2*(1-[S1_Cellularity]))/[S1_Cellularity])))
I need to use Max function to return 0 if the formula returns a negative value.
When I type this formula into a field, I get the following error when i run the query. "The expression you entered has a function containing the wrong number of arguments.
Could you please explain how I need to enter this formula correctly?
Thank you
CorrCN: Max(0,(([S1_Raw-CN]-2*(1-[S1_Cellularity]))/[S1_Cellularity])))
I need to use Max function to return 0 if the formula returns a negative value.
When I type this formula into a field, I get the following error when i run the query. "The expression you entered has a function containing the wrong number of arguments.
Could you please explain how I need to enter this formula correctly?
Thank you