Error in set expression

[yoganantha321]

I have been using this expression and it is throwing error anybody can help me..........

=Sum({<Num(Month(Date(Date#(Month,'MMM'),'MM')))={">$(=Num(Month(Today())))"}>} Value)

[pooja_prabhu_n]

Hi,

with reference to your thread expression required

Below expression is working fine for me with the sample data.

for loading script:

Num(Month(Date(Date#(Month,'MMM'),'MM'))) as Temp

Expression:

=Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value)

You can not use Num(Month(Date(Date#(Month,'MMM'),'MM'))) directly in set analysis.

What is the issue your facing with the below expression:

=Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value)

Thanks,

Pooja

[yoganantha321]

Hi Pooja,

For

Current Month

=Sum({<Temp={">$(=Num(Month(Today())))"}>} Value) the value is 0.08

For future Month

=Sum({<Temp={"<=$(=Num(Month(Today())))"}>} Value) the value is 0.08

both it is showing same value

But i need as current Month is 0.02 and future month 0.06

[pooja_prabhu_n · Accepted solution]

Hi,

That expression is working for me

PFA

Thanks,

Pooja

[yoganantha321]

I will check it. Pooja

[yoganantha321]

Thanks Pooja.

Its working fine.