Help Calculated Field Not working.
=SUM(IF([Jan 2013 Budget]>=0,[Jan 2013 Budget],0),0) In this instance Jan 2013 Budget is equal to 100. but my calculated field still displays $0.00. Is this not the right way to do a sumIf Any help would be greatly appreciated. Brandon
June 26th, 2012 3:11pm

Looks correct to me. Can you try to isolate the issue by just using the IF condition without the SUM and see if it is bringing back the right number?
Free Windows Admin Tool Kit Click here and download it now
June 26th, 2012 4:31pm

Hi! Hi, just for test propouse, can you try this? =SUMIF([Jan 2013 Budget],">=0",[Jan 2013 Budget]) MVP Office Development, MCP, MCTS SharePoint 2010 Development
June 27th, 2012 5:41am

Your formula is correct but looks like the column "[Jan 2013 Budget]" is not a Number field (may be Single line of text or other type) and all mathematical operations are performed only on number fields. Hope this helps!Prashobh P
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2012 5:47am

Hi, I would suggest to use =TEXT([Jan 2013 Budget]+[Jan 2013 LE]). I think this should solve your problem. Prateesh Nair (MCTS) | Orion India Systems
June 30th, 2012 12:54am

Hi, I would suggest to use =TEXT([Jan 2013 Budget]+[Jan 2013 LE]). I think this should solve your problem. Prateesh Nair (MCTS) | Orion India Systems
Free Windows Admin Tool Kit Click here and download it now
June 30th, 2012 12:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics