Hi All,What function could be used to Force Null value in a if() condition for data type as DATE/TIMESTAMP. I tried with NULL() and '' in the Argument 3 but it tells that data type is not same.Here is the eg:if(and(Inbound_Orders_SCO.Inbound_Orders.E...
Spoiler can this formula be achieved in Incorta? I have a segment column with multiple Inputs, but I want the output to be displayed in the report only if it met the below criteria. Sample output : R-B6W-001-ZDescription Standard as per Core Softwar...
How can I go ahead ? Kindly help in to this
Hi Community,I was trying to use the "In Query" operator for applying a filter based on the result set returned from Query within Insight Individual filters. But for some reason, the insight does not pull any records when the filter is enabled. And I...
Hi ,We are trying to use the Last_version filter in an aggregated table to get the counts of ID's for the last audit date for that ID. (v5.2.2)This use case is generating some values but they dont seem to make any sense. We are unable to understand t...
