2 of 2 people found this helpful
have you tried creating a calculated field with an if clause? Something like
IF Availability = "Available" then str(avg(price))
ELSEIF Availability = "Paused" then str(enable date)
ELSEIF Availability = "Due to pause" then str(pause date)
You'll probably have to wrap everything in str() to prevent errors.
Works like a charm, thanks!