topic Re: Sum(IF()) with two set analysis in App Development

Sum(IF()) with two set analysis

zyn — Fri, 11 Jul 2025 11:21:59 GMT

i want to use sum if with two set analysis but its giving me wrong answer can some one help on this, below is my expression:

sum(
if (
WildMatch(Measure,'BHR Fail','Total Fails'),
{<DITDate= {">=$(=(date(Max(DITDate)-6)))<=$(=(date(Max(DITDate))))"},Table_Flag = {'JAT'}>}Volume,
{<DITDate= {'$(=(date(Max(DITDate))))'},Table_Flag = {'JAT'}>}Volume
)

)

Re: Sum(IF()) with two set analysis

Chanty4u — Fri, 11 Jul 2025 11:23:40 GMT

Try this

Sum({

<DITDate = {">=$(=Date(Max(DITDate)-6))<=$(=Date(Max(DITDate)))"},

Table_Flag = {'JAT'}>

}

If(WildMatch(Measure, 'BHR Fail', 'Total Fails'), Volume)

)

Sum({

<DITDate = {"$(=Date(Max(DITDa

te)))"},

Re: Sum(IF()) with two set analysis

zyn — Fri, 11 Jul 2025 11:50:45 GMT

your expression in not working,
i want if my measure is 'BHR Fail','Total Fails' then it should take the whole weeks data from max date else for rest of the measure it should take only for max date,

but what is happening with my expression is that it is not taking any set analysis in sumif, it is only giving me sum of volume.

Re: Sum(IF()) with two set analysis

marcus_sommer — Fri, 11 Jul 2025 12:07:39 GMT

I think the logic should look like:

if(wildmatch(), Expr1, Expr2)

Re: Sum(IF()) with two set analysis

zyn — Mon, 14 Jul 2025 13:33:45 GMT

The reason i am using Sum( IF() ) is because i want to take selection but my chart values shouldn't change ,

by using this: if(wildmatch(), Expr1, Expr2), when selecting different rows my table is taking else condition and the numbers are changing:

For my measure Measure,'BHR Fail','Total Fails', it should take whole week data and for others it should take only max date, so when i select any other row which corresponds to max date, my Measure,'BHR Fail','Total Fails' are also taking max date data, can any one suggest how to achieve this.

Re: Sum(IF()) with two set analysis

rafaelencinas — Mon, 14 Jul 2025 14:09:43 GMT

Hi @zyn

Instead of use Sum(If () ) try this

Sum(
{
<
Measure = {'BHR Fail', 'Total Fails'},
Table_Flag = {'JAT'},
DITDate = {">=$(=Date(Max(DITDate)-6))<=$(=Date(Max(DITDate)))"}
> +

<
DITDate = {"=$(=Date(Max(DITDate)))"},
Measure -= {'BHR Fail', 'Total Fails'},
Table_Flag -= {'JAT'}
>
} Volume
)

Bye!

Re: Sum(IF()) with two set analysis

zyn — Mon, 14 Jul 2025 14:42:35 GMT

@rafaelencinas Thanks! your solution works.