116222 - no subject - #Appian 7.5\n\nI have a portal report wi

simranjits over 10 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....

Discussion posts and replies are publicly visible

Parents

0 ashishd over 10 years ago

There is no any in build function available which will format the data specified i.e. "5::23:48:35.802", but you can write an expression in the column to show it in the required format.
i.e. you can write below expression in report for Lag Column(Normal Text):

=split(joinarray(split(Lag(),"::"),":"),":")[1]&"-"&split(joinarray(split(Lag(),"::"),":"),":")[2]&"-"&split(joinarray(split(Lag(),"::"),":"),":")[3]&"-"&split(joinarray(split(Lag(),"::"),":"),":")[4]

This will return the data in dd-mm-hh-ss format.
Hope this works for you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ashishd over 10 years ago

There is no any in build function available which will format the data specified i.e. "5::23:48:35.802", but you can write an expression in the column to show it in the required format.
i.e. you can write below expression in report for Lag Column(Normal Text):

=split(joinarray(split(Lag(),"::"),":"),":")[1]&"-"&split(joinarray(split(Lag(),"::"),":"),":")[2]&"-"&split(joinarray(split(Lag(),"::"),":"),":")[3]&"-"&split(joinarray(split(Lag(),"::"),":"),":")[4]

This will return the data in dd-mm-hh-ss format.
Hope this works for you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data