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?