Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
My current measure is 'RangeSum({<SUM({Flag={181}>}Amount1),SUM({Flag={181}>}Amount2))' and i need fine Min from this measure. Please let me know how i can achieve this. attached the sample data.
Expected min value is -300
This should work: MIN(AGGR({<FLAG={'181'}>}SUM(AMOUNT1+AMOUNT2) ,ID))
Try: RangeMin( { < Flag={181} >} sum(Amount1), SUM(Amount2))