Hi Team,Could you please let me know how to convert below formula in Business view. I want to use te result of data in another formula.OR((MIN(table.[FISCAL_YEAR])) >= 2022, NOT(ISBLANK(SUM(table.[ORDER_INTAKE])))), SUM(table.[ORDER_INTAKE]), SUM(tab...
Hi,I have created below measure formula in business view using string to count the number of rows of string.Requirement: count(table.name = "Yes").Written formula in Business View:if( table.name = "Yes", count( table.name ), 0)Ca...
Hi there Community,I'm just starting my adventure with Incorta, so first problem appear, thats Why Im asking for help.I have a problem with the proper sorting of months, from what I can see they are sorted alphabetically, and I would like them to be ...
Hi everyone,I'm looking to write a formula such that the startdate of the year (Jan 1st) is obtained based on the year of the previous month.For example :if the input is "2022-01-01" then the formula should return "2021-01-01" (Since year of previous...
Hi Team,I want to retrieve min date from two tables and max date from two tables. Below is the formula. Please let me know how to achieve in Incorta.ADDCOLUMNS( CALENDAR( MIN( MIN( Table1. Date), MIN(Table2.Date) ), MAX( MAX( Table1....
