Is there a way to create Case Statements? & nested calculations

[darcoli]

you can do that as long as you keep the same aggregation level throughout.
In your example this means that {calculated field example} should not use aggregate functions such as SUM(), MAX() etc