eazyBI tries to detect results type from the formulas you are using. It is easier when you use a formula for each case separately.
CASE condition results could be different data types. However, all cases of one formula should be of the same data type.
eazyBI in many cases can’t detect the one correct data type from formulas with CASE condition. You would like to to convert results to particular data type explicitly for each case result part.
In most cases, you have a numeric results.
You can use
Val(your formula goes here) or
Nonzero(<your formula goes there>) for setting numeric result explicitly.
Daina / email@example.com