topic Re: Values are not coming for some records by using IF statement in App Development

Values are not coming for some records by using IF statement

dineshm030 — Tue, 11 Apr 2023 02:00:16 GMT

Hi All,

Both measures are the same. But the 1st measure shows all values whereas the 2nd shows only two products value.

1st Expression:

Sum({<Version_Desc = {'Actual','Adjustment'},ContinuousDay = {"<=$(=max(ContinuousDay))"}, YearOffset = {"$(=max(YearOffset)-1)"},Year,Month,Date_Key,Day_of_Week>}Sales_Value)/1000

2nd Expression:

If(Day_of_Week = 10,
Sum({<Version_Desc = {'Actual','Adjustment'},ContinuousDay = {"<=101"}, YearOffset = {"$(=max(YearOffset)-1)"},Year,Month,Day_of_Week>}Sales_Value)/1000)

Could you please help me out.

Thanks in advance @marcus_sommer @MayilVahanan @sunny_talwar

Re: Values are not coming for some records by using IF statement

marcus_sommer — Tue, 11 Apr 2023 05:42:23 GMT

Both expressions are not the same. I assume that in both cases the ContinuousDay <= 101 - one time calculated and one time as fixed value - but the second aggregation is included within another expression - the if-loop - and of course this will have an impact.

Re: Values are not coming for some records by using IF statement

Sabrina_V — Tue, 11 Apr 2023 06:46:26 GMT

I'm agree with @marcus_sommer The two formulas are not the same.

On the first one, you used a variable to filter the field ContinuousDay.

On the last one, you fixed a value 101 and you added a condition on another field Day_of_Week.

What are the rules you need to apply ?