topic Re: Min Amount from Rangesum in App Development

Min Amount from Rangesum

loganathan — Tue, 22 Apr 2025 14:46:46 GMT

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

Re: Min Amount from Rangesum

mdf — Tue, 22 Apr 2025 15:02:11 GMT

This should work: MIN(AGGR({<FLAG={'181'}>}SUM(AMOUNT1+AMOUNT2) ,ID))

Re: Min Amount from Rangesum

marcus_sommer — Wed, 23 Apr 2025 12:12:56 GMT

Try: RangeMin( { < Flag={181} >} sum(Amount1), SUM(Amount2))