1 Reply Latest reply on Jul 1, 2016 12:07 PM by Ivan Young

    Local time calculation by using a parameter

    Winson Lui

      HI,

       

      I would like to create a world local time dashboard.

      My though is to create a parameter and let the reader input their local time. The dashboard will then automatically show the corresponding time of each country.

      I now have an excel spreadsheet which includes country name and GMT +/- hour.

      I tried to create a parameter and do a sum but firstly, the parameter does not accpt hour only option and second the sum will show a negative number which is actually a night time. (e.g. 1am GMT – 5 = - 4 local time, but actually it should be 8pm local time.)

       

      Do you have any idea I can wotk on this?

      Thanks.