Less then equal to not working in set analysis

[Anonymous]

Hi Geniuses

I have a problem in set related with less then equal to

sum({$<Year = {$(vThisYear)}, Month = {"<=$(=vThisMonthText)"}>} [Product Bookings Net])

Above formula is not working when I am using less then equal to after month

require ur assistance

Thanks,

Shashnak

[Miguel_Angel_Baeyens]

Hi Shashnak,

Since your Month is in text, and less than or equal to is a numeric operator, this will not work. You will need to create an additional field in the script where the Month is stored in numeric value, like the Year, and use this new numeric field in the variable. That will fix it.

Hope that helps.

Miguel

[#3]

Hi Shashnak,

Can you attach a sample document? You may need an = in front of vThisYear What about:

sum({$<Year = {$(=vThisYear)}, Month = {"<=$(=vThisMonthText)"}>} [Product Bookings Net]) or

sum({$<Year = {"$(=vThisYear)"}, Month = {"<=$(=vThisMonthText)"}>} [Product Bookings Net])

Have you tried that?

Andy

[CELAMBARASAN]

Hi,

If you created a field with Month() function. Then you can use <= operator but you should compare this with string.

May be something like this

Assuming that

vThisMonthText = Max(Month)

where Month field arrived from Month(DateField)

sum({$<Year = {$(vThisYear)}, Month = {"<=$(=vThisMonthText)"}>} [Product Bookings Net])

[rbecher]

This wont work since vThisMonthText is not numeric: '2' > '10'

[#6]

Or you could use the Dual function right? Something like Dual(month, autonumber(month)) as month.

[MayilVahanan]

HI

Try like this

Use DateField, i think Month is in text format

SUM({$<DateField = {"<=$(=MonthStart(max(DateField)))"}>} [Product Bookings Net])

Hope that helps

[kalyandg]

hi,

try this

sum({$<Year = {$(vThisYear)}, Month = {"<=$(vThisMonthText)"}>} [Product Bookings Net])

Thanks,

Kalyan

[Anonymous]

Hi Geniuses,

Please find attached qvw which I am refering to calculate YTD MTD

In this go the sheet set analysis static and go the pivot table at bottom u can see the formula there

he is comparing the text month with the number and getting desired result

in my case the variables are below

vThisMonth is number

vThisMonthText is text lik Aug sep

Month dimension is Aug Sep

now please enlighten me guys

Thanks

[tresesco]

Dear Shashank,

As already told by Celambarasan Adhimulam, you can use '<=' operator if the month values are created using  Month() function (you can notice the same in your referred application). So it could be a major point of consideration how you are creating this month field. Best way people here can help you, if you can upload your sample application.