Forum Discussion
Fariba_150
Aug 02, 2020Copper Contributor
having trouble with Spill error!
Hi everyone,I am a beginner. I am learning about Creating Calculated Fields, using IF function. I am following exactly Microsoft Excel 2019 instruction but I am keep getting Spill error. This is Wh...
SergeiBaklan
Aug 03, 2020Diamond Contributor
Most probably you mean
=IF([@Speciality]="Loans",[@[Account Values]]*0.0025,0)
i.e. formula is for the current row of the table, not for entire column