I want to subtract two date, but I am able to execute that in BI Table, but while downloading data the subtraction of date is automatically getting converted in to "###########:" format is there any way where we can get ####### in to proper format as soon as we download data from BI
Hi, is this "###########" means some kind of number or this is format you see, just a string from hashtags? Can you provide one sample of what you see? Are you see these "###########" in excel? Qlik?
On excel ##### means, that cell is to small for value, but it is here. Easiest way to make it fit is to change column width or double click between columns letters, A,B,C... when mouse cursor become <-|-> :
What why I asked to provide at least one sample of your duration you see in BI, and what you get. Because, if you have duration in, for example, 0.5451215 format, you can change this number format to 'duration' format pattern h:mm:ss and see 13:04:58 (function time(0.5451215, 'h:mm:ss') ).
