Expression help????

[amit_saini]

Hi Folks ,

I'm having expression as below: (here Test and vDeliverced are two varibles)

sum({<Year ={$(=Year(AddMonths(now(),-1)))}, AccumType = {'YTD'}, [Major Defect Group]=, Month = {"<=$(=num(month(AddMonths(now(),-1))))"}> }$(Test)) / sum({<Year ={$(=Year(AddMonths(now(),-1)))}, AccumType = {'YTD'}, [Major Defect Group]=, Month = {"<=$(=num(month(AddMonths(now(),-1))))"}>}$(vDelivered))*1000

This expression given be bars with same numbers, looks like something wrong.

Kindly help.

Thanks,

AS

[MK_QSL]

What is your Month Field looks like... is it in Number format or Text...

[avinashelite]

Hi Amit,

Can you kindly post your app here, so that we can analyse the problem.

Regards,

@vi

[amit_saini]

Manish,

It having values like Jan Feb March....

Thanks,

AS