locked
Help Calculated Field Not working. RRS feed

  • Question

  • =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

    Tuesday, June 26, 2012 7:11 PM

Answers

  • 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

    Saturday, June 30, 2012 4:54 AM

All replies

  • 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?
    Tuesday, June 26, 2012 8:31 PM
  • 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

    Wednesday, June 27, 2012 9:41 AM
  • 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

    Wednesday, June 27, 2012 9:47 AM
  • To start off Joao that did not work. Also both my Jan 2013 Budget column is a Currency and so is my calculated field. Also I switched both to a number and still nothing. When I do the If statement it brings in the correct number. So the =sum is the problem... But I am not sure what that problem is.

    Brandon

    Edit: So I also tried just doing =SUM([Jan 2013 Budget], [Jan 2013 LE])

    Both those columns have the # 100 and it gives me zero. but when I do =([Jan 2013 Budget]+[Jan 2013 LE])

    it gives me 200...

    Does it matter that Jan 2013 Budget and Jan 2013 LE are both Calculated columns as well.. I don't think it should

    Brandon


    • Edited by blnigro Wednesday, June 27, 2012 12:26 PM
    Wednesday, June 27, 2012 12:08 PM
  • 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

    Saturday, June 30, 2012 4:54 AM