Hi there, I’m looking for a Valid If expression in a Date Type column that gives an error when the given date lays in an earlier month as the month of today. Example: Today is February 2, 2021. Valid input: February 1, 2021 - May 28, 2021 Not valid: ...

I’ve got this expression: SELECT( OrderMaandBudgetten[_ROWNUMBER], ([_THISROW].[Order ID] = [Order ID]) ) I’m looking for a list of rownumbers which correspond to the current row based on Order ID. However, right now it returns just one rownumber. Th...

Hi, I am looking for an expression to return one value which is used to do a calculation with. What I try to accomplish here is the following: I have ‘Table X’ and ‘Table Y’. There is an action that is triggered when a new row is added to ‘Table X’. ...

I’ve got a specific problem and couldn’t find the answer in related topics… My data looks like this: Agencies (with columns like: agency ID, agency name etc.) Clients (with columns like: client ID, client name, agency name etc.) Orders (with columns ...