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.myCond = .T.,a.myOption1,a.myOption2)) AS n_amount.
Thanks for your help
Thanks in advance