I am trying to create a formula that will return a null value if the relevant criteria are not met.  I have previously been returning a zero, but this is no good if I want to find my lowest return, as the lowest number will always be zero....

 

Current formula is

 

if {A_PRICES.PRICE_TYPE}="Ask" then {A_PRICES.PRICE} else 0

 

but I want to write

 

if {A_PRICES.PRICE_TYPE}="Ask" then {A_PRICES.PRICE} else null

 

but get a incorrect string message :(

 

Any help greatly appreciated!!

 

Thanks

 

John

Consider using a Running Total with a evalaute formula that uses your conditions.