Forum Discussion

slounsbury's avatar
slounsbury
Helper II
8 years ago
Solved

Adding Units To Calculated Column

This is probalby a super easy solutions to this but after trying several different methods from the forum I couldn't get it to work. I have several columns that I need to either have time units added to them (ie. Hour, Day, Minute).

 

Here is an example of one of my columns that needs to have the "Days" unit added:

 

ART = ABS(DATEDIFF(v_rpt_Service_SLA[Date_Responded_UTC], v_rpt_Service_SLA[ART_ST],HOUR))

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Am not sure this is what you expect ....Please let me know if you need something else  :)

     

    Adding & "Days" at the end of your formula will solve the problem.

     

    ART = ABS(DATEDIFF(v_rpt_Service_SLA[Date_Responded_UTC], v_rpt_Service_SLA[ART_ST],HOUR)) & "Days"

     

    Thanks

    Raj

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi

    Could you please make the question clear ?  OR Can you please post some details / sample with what do you have and what do you expect?

     

    Thanks
    Raj

    • slounsbury's avatar
      slounsbury
      Helper II
      8 years ago

      Of course, I have all three of these columns of which the last one I created through a DATEDIFF calculation as shown above. Currently It looks like this:

      Date_Responded_UTCART_START
      11/6/17 8:00 PM11/7/17 8:00 PM1
      11/7/17 8:00 PM11/11/17 8:00 PM4

       

      I am wanting it to look like this:

      Date_Responded_UTCART_START
      11/6/17 8:00 PM11/7/17 8:00 PM1 Days
      11/7/17 8:00 PM11/11/17 8:00 PM4 Days
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Am not sure this is what you expect ....Please let me know if you need something else  :)

         

        Adding & "Days" at the end of your formula will solve the problem.

         

        ART = ABS(DATEDIFF(v_rpt_Service_SLA[Date_Responded_UTC], v_rpt_Service_SLA[ART_ST],HOUR)) & "Days"

         

        Thanks

        Raj