Skip to Content
0
Former Member
Jul 02, 2014 at 07:33 AM

WebIntelligence - InData function

46 Views

Hi,

I'm migrating a certain number of reports from SAP BO XI R2 to SAP BO XI R4. In one old report I have found this formula:

=InData(FormatNumber(SUM1/SUM2*1000;"#");"hh:mm:ss")


used to convert a certain avarage ammount of seconds in the format hh:mm:ss.


In the new release of SAP BO XI R4, it's not possibile to apply the same function InData, since it can be used only with a string_data, and not with a string. I've tried different workarounds but none of them was successful.


Is there any suggestion to get through it?


Thank you very much for your help