locked
How do i make this formula work?? RRS feed

  • Question

  • =iif(

    (Code.MinutesToHoursMinutes((Sum(Fields!TotalPostStartHrs.Value)) - (Sum(Fields!ThisMonthTotalPostStartHrs.Value)))) >="12",

    “12” - Code.MinutesToHoursMinutes((Sum(Fields!TotalPostStartHrs.Value)) - (Sum(Fields!ThisMonthTotalPostStartHrs.Value)) +(Sum(Fields!ThisMonthTotalPostStartHrs.Value)) ) , Code.MinutesToHoursMinutes(Sum(Fields!LastMonthTotalPostStartHrs.Value))

    )

    Any help much appreciated

    Thanks


    Pradnya07

    Wednesday, November 6, 2013 11:51 AM

Answers

  • reply done it by convertinng 12 hrs in 720 mins and it worked like a charm


    Pradnya07

    • Marked as answer by Simran08 Wednesday, November 6, 2013 3:22 PM
    Wednesday, November 6, 2013 3:22 PM

All replies

  • And what's the issue here? Do you get an error message or ...? Why do you use the fix value "12" as a string and not as a numeric?

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Wednesday, November 6, 2013 12:04 PM
  • thats right 12 creates an issue when i remove 12 it works

    Pradnya07

    Wednesday, November 6, 2013 12:05 PM
  • reply done it by convertinng 12 hrs in 720 mins and it worked like a charm


    Pradnya07

    • Marked as answer by Simran08 Wednesday, November 6, 2013 3:22 PM
    Wednesday, November 6, 2013 3:22 PM