Sign in to join the conversation:
=SUM[Invoiced Jobs]2:[Invoiced Jobs]50*0.2)) ..Not working ???
Try to say =SUM[Invoiced Jobs]2:[Invoiced Jobs]50 X 2%))
Hi Graeme,
you have the 2% inside the parenthesis of the SUM. Take it out and it will work=SUM([Invoiced Jobs]2:[Invoiced Jobs]50)*0.02
Regards, José Joaquín.
Thank you Jose