Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Please help me below thread.
I have master calendar in that I have Year, Month Quarter Fields. I want write expression like below.
1. If I have select any year then values should display next year first month.
for e.g: If I have select fin Year 2017-18 then values display April 2018
If I have select fin Year 2016-17 then values display April 2017
2. If I have not done any selection then values should only max month.
3. If I Have select max FinYear then values should max month.
Thanks & Regards,
Arvind Patil
If possible, Can you Attach you qvf file ?
Sorry to say but i cant attach Qvf file .
If you require more clarification then i will provide you.
Regards,
Arvind Patil
Can you tell me on what all the Calendar Related Fields available in data, along with sample of 2 transactions.
How about this one.
=If(GetSelectedCount([Fin-Year])>=1,SUM({<MonthName={'$(vMinMonth)'}>}Value),SUM({<MonthName={'$(vMaxMonth)'}>}Value))
Regards,
Renuka S
You selecting single Year or Multiple year?
If you select 2018, it should show the month start from apr?
And if you select 2017, month should start from 2017-Apr?
or Just show Apr month if a Year is selected and then you manually select other months?
Hi!
Check this:
Store the max finyear in a variable ($(maxFinyear))
If(Finyear<>$(maxFinyear), Monthname(yearstart(addyears(Finyear,1))), month(max({1}Finyear)))
RC
Hi AP,
Try with making new field as left([Fin Year],4) as [Fin Year New]
then
if([Fin Year New]-=vMaxFinYear,vNextYearMonthStart,vMaxMonth)
Just a rough idea.
Regards,