Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
9 replies
Subscribers
5 subscribers
Views
2737 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
116222 - no subject - #Appian 7.5\n\nI have a portal report wi
simranjits
over 9 years ago
#Appian 7.5
I have a portal report with Lag() function as a column definition. This returns a "duration". In my process model, I am using Execute Process report smart service. Although the portal report shows data in the format: "5 days 23 hrs 48 mins", the same data obtained via the smart service comes in the format: "5::23:48:35.802". How should I format the data so that value is obtained in dd-hh-mm format.
I tried using todecimal(Lag()) as the column definition(this was mentioned in one of the earlier forum posts) on the portal report but with no success. Please suggest....
OriginalPostID-116222
Discussion posts and replies are publicly visible
Parents
0
TJ
A Score Level 2
over 9 years ago
=load(
var:reject(fn!isnull,split("5::23:48:35.802",":")),
var[1]&"-"&var[2]&"-"&var[3])
Replace data in local!var with your function
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
TJ
A Score Level 2
over 9 years ago
=load(
var:reject(fn!isnull,split("5::23:48:35.802",":")),
var[1]&"-"&var[2]&"-"&var[3])
Replace data in local!var with your function
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data