implement a if function in the output field ?

[#1]

Hi Qlikview Community,

how can I share the value of Berlin in the output field by half ? Please see screenshot.

Instead of 300, should be displayed 150. All other cities would not be affected. How can i implement an if function there?

Thank you !

[fernandotoledo · Accepted solution]

=sum(Income)/if(City='Berlin',2,1)

[#3]

Thank you Fernando !

Best Regards,

Onur