>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
Just put the IIF() only in the report field, and set it to calculate the sum (rightclick the field).