topic Set Analysis not working because of single digit month in App Development

Set Analysis not working because of single digit month

Applicable88 — Mon, 11 Jan 2021 10:19:57 GMT

Hello,

I'm using a set analysis to sum the sales of a table like this:

Sales	Year1	Month1
1234	2021	01
2321	2021	01
1231	2021	01
32123	2021	02
12312321	2021	03
123123	2021	03
7676578	2021	04

It took me a while to find the problem, since it worked out last year. So I just realize when I finished that App it was from October on. And from October on, we have two digit Month i.e. 10-12

It works out without problem for my num(year(today())) part. But not for month:

Sum({1<Year1={"$(=num(year(today())))"},Month1={"$(=num(floor(month(today()))))"}>}[Sales]))

So when I now just put the num(month(today())) in a KPI Window the number of today's month won't display as "01" but as "1".

So I guess for set analysis 01 is not the same as 1?

I hope someone knows a workaround to this.

Thanks.

Re: Set Analysis not working because of single digit month

PrashantSangle — Mon, 11 Jan 2021 10:26:44 GMT

in your script just do below change

num#(Month1) as Month1

Regards,

Prashant Sangle

Re: Set Analysis not working because of single digit month

Frank_Hartmann — Mon, 11 Jan 2021 10:36:09 GMT

try this:

num(month(today()),'00')

Re: Set Analysis not working because of single digit month

Ksrinivasan — Mon, 11 Jan 2021 11:08:33 GMT

Hi, are you sure, was single digit month cause of problem? It happened to me also. But first two days or considered as date, 3rd and forth day was not considered as date. When two files were merged like CSV and XLS. It was formed like that. Pl. Confirm that whether single date not shown from single digit date.

Regards,

Ksrinivasan

Re: Set Analysis not working because of single digit month

Applicable88 — Mon, 11 Jan 2021 11:39:04 GMT

Thank you! That displayed the month as 01 and worked out.

Re: Set Analysis not working because of single digit month

Applicable88 — Mon, 11 Jan 2021 11:42:34 GMT

thank you for your tip. It indeed was "one" of the problems. I really needed to make 01=1 work first, to filter the right sales data. But there was really also another mistake that I had to figured out.