Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one expression written in set analysis i.e.
=SUM({<Period_NR={'>=$(=vCurrYear_SelectedMnth1)'}>}IB_1)
This expression is working fine and i getting correct result.
I have written one more expression i.e.
=SUM({<Period_NR={'>=$(=vPrevYear_SelectedMnth1)'}>}IB_1)
This value is showing wrong is there anything i have written wrong.
In the variable vCurrYear_SelectedMnth1 i have written getfieldselections(Period_NR)
In the variable vPrevYear_SelectedMnth1 i have written AddMonths(getfieldselections(Period_NR),-12).
Please suggest
Thanks,
Bharat
You seem to need a single day, yet you use >=... can you elaborate why? Seems to work without it
=SUM({<Period_NR={'$(=vPrevYear_SelectedMnth1)'}>}IB_1)
Hi,
Maybe
=SUM({<Period_NR={'>=$(=vPrevYear_SelectedMnth1)'},Period_NR=>}IB_1)
There could be multiple issues
1) Do you select just one Period_NR?
2) Do you make selection in any other date or time field other than Period_NR?
3) What is the format of Period_NR field?
Thanks for the quick reply Mukram, but the expression what you have given i m getting wrong..
Hi Sunny,
Yes there will always one selected.
I don't make any other selection in any other date or time field.
format is given below image
Please let me know if you require anything more..
Try these
=Sum({<Period_NR = {">=$(=Date(AddMonths(Max(Period_NR), -12), 'MM/DD/YYYY'))"}>} IB_1)
Hi Sunny ,
I have tried your expression but the value is wrong:
Please see the below images :
When i select the current month i m getting correct value
The same when i select last year i.e. 07/01/2016 instead of 4392 i m getting 83908
Is it the same text box? If it is then when you selected 07/01/2016, it is showing the value from 07/01/2015
Hi Sunny,
Please find the attached app which will be helpful.
Thanks,
Bharat
Try this
=Sum({<Period_NR = {"$(=Date(AddMonths(Max(Period_NR), -12), 'MM/DD/YYYY'))"}>} IB_1)