Set expression not working returning '0'

[Anonymous]

Hi Everyone

I've been trying to get below set expression to work. However, I can figure out what I'm doing wrong.

As you can see, the first Set Expression is concerning Months, and the second is concerning Year.

Can it be something with the structure of the datafield AD_CAL_MONTH? It contains the data 01,02.....12.

I hope that someone can help

Stefan

[manideep78]

add this instead of AD_CAL_MONTH

(=only(num(AD_CAL_MONTH,'#'))-1)

[Anonymous]

It still returns '0'

Sum({$<AD_CAL_MONTH={$(=only(num(AD_CAL_MONTH,'#'))-1)}>}if(CUSTOMER.CGRNO <> 'IA' And CUSTOMER.CGRNO <> 'KA' And CUSTOMER.CGRNO <> 'BA' ,  New_NET))

[manideep78]

what is the expected output and can u post the sample app??

also what is the data that present in AD_CAL_YEAR field?

[sunny_talwar]

Are you selecting a single AD_CAL_MONTH? May be try this

Sum({$<AD_CAL_MONTH = {$(=Num(Max(AD_CAL_MONTH)-1, '00'))}, CUSTOMER.CGRNO -= {'IA', 'KA', 'BA'}>} New_NET)

[Anonymous]

Hi Sunny

That worked perfectly thanks

And Manideep thanks for your suggestion to.

Best

Stefan

[sunny_talwar]

No problem

[manideep78]

mark the correct answer and close the thread 🙂

[Anonymous]

There is NO green star "Correct Answer" to click?!