Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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
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
Hi,
That expression is working for me
PFA
Thanks,
Pooja
I will check it. Pooja
Thanks Pooja.
Its working fine.