Why This set analysis not work?

[Anonymous]

Hi all,

I post the sample where my set analysis not work ..

Thank to all

Andrea

[IAMDV]

Andrea - You are welcome. I am glad it works for you.

I am attaching a Demo App for Point In Time Reporting. Please be aware that I have not created this App. I have picked up from community and using this as reference.

Cheers - DV

[Miguel_Angel_Baeyens]

Hi Andrea,

It doesn't work because there cannot be ranges using literals, in your case 'dic-10' is a string (although returned by a Date()) function) and dealt as such as a literal (so the order is not >= or <=) To solve this, create a Date field in your script, using MakeDate(Year, Month) for example (it will return the first day of each month) and use this field in the set analysis instead of the year month field.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

[Anonymous]

DV ,

Thank very much for sharing .. is veru useful

Ciao

Andrea

[Anonymous]

Ciao Miguel,

thank for your answer.

The problem was a the formating issue like DV said.

If u get my projet i have post , and put set analysys DV wrote it's works

Ciao Miguel and thank