Hi all,
I need to build a conditional SUM and I want to include it in a Report.
I have the following instruction that works in an SQL statement but not like a fixed field at report´s feet.
SUM(IIF(a.plan,a.val_cuot,a.amount)) AS n_amount.
TIA
Thanks in advance