Set Analysis help

[abhaysingh]

Hi,

how to put below condition in set analysis

thanks in advance

if(sum({<Bucket = {'1 YR'}>}VMKUM) > sum(STOCK1), sum(STOCK1),sum({<Bucket = {'1 YR'}>}VMKUM))

[Gysbert_Wassenaar]

That if statement can't be transformed into a set analysis expression. It has two branches that each calculate a result.

[avinashelite]

Agree with gwassenaar‌ since it has branch statement we need to use If condition 

[sunny_talwar · Accepted solution]

How about this?

RangeMin(Sum(STOCK1), Sum({<Bucket = {'1 YR'}>}VMKUM))

[abhaysingh]

getting same output as if condition.. thanks

[sunny_talwar]

It does, its just another way to avoid the if statement in your case