Min Date with Or Condition

[KHK]

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(table[OPEX_PRICE]))

[anurag]

OR will work at the row level and you have aggregation inside OR function.

One option you have is:

You can aggregate your data using resultset and then apply OR function to the output of the resultset.