Forum Discussion
Drop Seconds from Duration Measure
BICrazy ok no worries, however the second script i posted does work.
you should just return your variables without the ts
VAR tH = IF(Hours=0,"",IF(Hours>1,Hours&" Hours, ",Hours&" Hour, "))
VAR tM = IF(Minutes=0,"",IF(Minutes>1,Minutes&" Minutes, ",Minutes&" Minute, "))
VAR tS = IF(Seconds=0,"",IF(Seconds>1,Seconds&" Seconds",Seconds&" Second"))
RETURN
CONCATENATE (th, CONCATENATE ("",CONCATENATE (tm,CONCATENATE )))
Hi Vanessafvg,
I tried not returning the seconds and the code doesn't work after that. I think the entire needs to accommodate dropping the seconds.
BICrazy what error are you getting? you can return what you want, setting the variable doesn't mean you have to return it
BICrazy does your code run with you original script?
vanessafvg
If I don't return the seconds, I receive the following error: Failed to resolve name 'CONCATENATE'. It is not a valid table, variable, or function name.
The 2 codes that I posted are created as 2 separate measures and the latter is dependent in the 1st measure.