Logic for Calculating LFYTD (Last Fiscal Year to Date)
Hi Team, can anyone help me with the formula for calculating growth of previous FYTD. Fiscal year starts on April 1st and ends on Aug 31st.
Hi Team, can anyone help me with the formula for calculating growth of previous FYTD. Fiscal year starts on April 1st and ends on Aug 31st.
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...