Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BO4 - Trying to create fromulad based ion date variable


Have following situation

sql in report has below


result is that when the transaction.column_name has value of 0 in it  (numeric datatype on database) then shows 00:00:00 in report - custome format on object in universe.

Trying to do  follwoing

If FormatDate(<object>;"HH:MM:SS")  = "00:00:00:00)   Then 1 Else 0

some of these values are 00:00:00 but some are populated with non-zero vlaues but our report variable seems to think all are 0.

How can we achieve this?


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question