topic Re: Set Analysis - Two or more values in a variable in App Development

Set Analysis - Two or more values in a variable

madnanansari — Fri, 05 May 2017 16:04:12 GMT

I have the below formula for Invoice count.

There is a filter bar on the top of the page which has [Year Month] and other filters. If there is no selection in [Year Month]; the below formula shows the information for the current month. (Line No1).

When there is a selection in [Year Month] let say Jan-2017, the formula shows the value for that month. (Line 2).

What changes I have to make in the below formula so that it shows data for multple selection in [Month Year] filter. Let say Jan-2017 and Feb-2017 and more.

If(getselectedcount([Month Year])<1,

Count({$<[YearMonth No]= ,[Year] = ,[Month No]=,[Month Year]=,[Month]=,[MonthID]= {"$(=((Year(Today()) -1)*12) + Num(Month(Today())))"}>} [Invoice No])

Count({$<[YearMonth No]= ,[Year] = ,[Month No]=,[MonthID]=,[Month]=,[Month Year]= {"$(=getfieldselections([Month Year]))"}>} [Invoice No])

)

Re: Set Analysis - Two or more values in a variable

Anonymous — Fri, 05 May 2017 16:32:19 GMT

I think it will work if you simplify the second line, give it a try:

...

Count({$<[YearMonth No]= ,[Year] = ,[Month No]=,[MonthID]=,[Month]=>} [Invoice No])

...

Re: Set Analysis - Two or more values in a variable

madnanansari — Sun, 07 May 2017 07:47:20 GMT

this brings the count for all. Not what is required.

Re: Set Analysis - Two or more values in a variable

Anonymous — Sun, 07 May 2017 16:14:50 GMT

Saying "second line" I mean your 2nd expression i the if() statement. The full expression will be:

If(getselectedcount([Month Year])<1,

Count({$<[YearMonth No]= ,[Year] = ,[Month No]=,[Month Year]=,[Month]=,[MonthID]= {"$(=((Year(Today()) -1)*12) + Num(Month(Today())))"}>} [Invoice No])

Count({$<[YearMonth No]= ,[Year] = ,[Month No]=,[MonthID]=,[Month]=>} [Invoice No])

)

I also assume that the filter [Year Month] and the field [Month Year] in the if() condition is the same field, just a typo in your opening post (?)

Re: Set Analysis - Two or more values in a variable

swuehl — Sun, 07 May 2017 17:56:16 GMT

Why not just use

Count( [Invoice No])

in the else branch of your if() function? What should the set analysis do other than the selections would do anyway?

Re: Set Analysis - Two or more values in a variable

Anil_Babu_Samineni — Mon, 08 May 2017 04:44:11 GMT

Still facing issue, Can you elaborate more. If Jan-2017 selection happened what is the output you want to show?