WebIntelligence - InData function

[Former Member]

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

[Former Member · Accepted solution]

Hi,

You can do below workaround-

Create variable-

V_Sec=FormatNumber(SUM1/SUM2*1000;"#")

V_Time=Floor([V_Sec]/3600 )+":"+Floor(Mod([V_Sec];3600)/60)+":"+Mod(Mod([V_Sec];3600);60)

~Anuj

[Former Member · Accepted solution]

Hi Anuj,

thank you very much, it works!

Have a nice day,

Francesca