Logic help

[ganeshreddy]

Hi All,

I am having trouble while implementing code for qvd generation. Here in the attached code i am getting KPI(newly added fields) data for only the months of Sep 2015 and Oct 2015, but according to the requirement i need to calculate July 2015 KPI first to add to summary qvd after that i need to add August 2015 KPIs to it and so on. Please help to implement this code and please find the attached file.

Note :   we can hardcode month names in script .

Best Regards,

Ganesh

[marcus_malinow]

Ganesh,

in your KPI 1to 8 loads you have a condition:

and wo_completionDate >= Addmonths(monthStart(Today()),-1) and wo_completionDate <= monthEnd(Today())

If you remove this you'll generate data for all periods.

Marcus

[ganeshreddy]

Hi All,

Can anyone help me on this.

Thanks in advance,

Best regards,

Ganesh