I'm trying to build a CASE formula in the new workbook feature and I'm having a problem. I basically want to create a formula to pull in amount based on transaction type so "CASE when {type] = 'Bill' then {amount} else 0." In the workbook I believe I have to use TO_Number function to convert field values that are in multiple currencies in which case if I try to use 'else 0' I get an error...what's the correct way to end the CASE statement to return 0?

Did you included the "End" to close the statement?

Yes I included "End" the issue is with the return zero I think. The error message is that CASE must have the same result type so it's something to do with TO_Number is FLOAT versus 0 being an Integer

You may be able to just End it, without an Else statement.