Skip to Content
0
Dec 30, 2022 at 04:35 PM

I want to calculate time Stamp(String format in universe) to minutes

85 Views Last edit Dec 31, 2022 at 08:43 AM 3 rev

I want to calculate time Stamp(String format in universe) I have used variable IN Webi SAP BO

=Sum(ToNumber([NOTES].[Time Spent])Where( [NOTES].[Time Spent] > "0" ))

but using this variable i am no able to get correct result.
result with this calculation is not matching with raw data
Kindly help