MIN function refuses to calculate when each parameter is a formula rather than a single field?

Question

Hello! I have the following formula that I keep on getting an error message on, and I'm not sure why:MIN(
DDIFF([Days in Invoice Billing End Date],[Days in Invoice Line Item Service Date]),
DDIFF([Days in Invoice Line Item Service Date],[Days in Invoice Billing Start Date])
)This results in an error. However, each of those DDIFF expressions work fine when on their own. For example (the last two columns correspond to the individual DDIFF formulas):However, in some ca...

HamzaJ · Accepted Answer

Hey Jake_Raz ,lThe min-function does not work like that. You can only offer it 1 measurement. You could use an group by aggregation, however this means you need to add a dimension (or atleast not a calculation of a field). Like min(days by date, DDIFF([Days in Invoice Billing End Date],[Days in Invoice Line Item Service Date])) will generate the minimum found value for that date.If you want to achieve what you are looking for you will need to use a CASE-function. So something like...