I'm using

if {field1} = "this_string" then {field2}

to display two columns in a report seperately, which are previously showed by a single currency column with the type identified next to it by "this string". So the display method is just the other way round.

However, this simple formula comes out with £0.00 for both columns, as if the the result is boolean - true / false? Have I got the wrong syntax? I wanted the value out (field2) and can't see why that doesn't work!

When "this_string" is different things it should give relevant values. The formula is copied with various strings in there...

Thanks

Yeah - it's a nvarchar(15) and it's got the value specified in quotes listed

I expected after the THEN, the formula would display the value in {field2} but in every row I just get 0


Thanks