i want date differences. i have date as TranDateNum... i am calculating like TranDateNum-above(TranDateNum) but i failed to get the result
can please help what is the best expression here.
are you sure you have only one TranDateNum value for dimensions ?
give a try with below:
TranDateNum - Above( Only(TranDateNum) )
i am sure there is only one TranDateNum .
TranDateNum - Above( Only( TranDateNum) ) ---> let me try with this.
thanks for your replay
Try this as well might be it should worked
=TranDateNum - DATE( Above(TranDateNum) )
=INTERVAL( TranDateNum - DATE(Above(TranDateNum) ) ,'DD')
i have a doubt TranDateNum in in Number format if i use DATE(Above(TranDateNum)) it will convert into date format.
how can i subtract num with date.
Ohh then convert first it into date format may help you change into your desired date format.
=Date(TranDateNum) - DATE( Above(TranDateNum) )
=INTERVAL( Date(TranDateNum) - DATE(Above(TranDateNum) ) ,'DD')
in above picture Trandate is already in date format
in the above i am not able to get values for Above(TranDatenum)
Then why you write previous "TranDateNum in in Number format" please check format once.
TranDateNum is date field which is in number format.
try change the expression in Above(TranDatenum) to see what you get for the first two rows.
for Above(TranDatenum) i am not getting any values.
i am not getting what is the problem . can you suggest me any solution.
Retrieving data ...