Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to calculate number of months yearwise based on calendar table
I am doing count(yearmonth) to calculate number of months , yearmonth is column in calendar table
when i am adding other dimension in my chart it is giving wrong value 3 instead of 5 for current year 2019
Yes , it was sample data, i tried your solution on sample data , its working thanks
I will try on real data and will let you know thanks!!
its not working actually
sorry, i forgot to mention there is a data for 12 months in my calendar table for 2019, in this case count(TOTAL<Year> YearMonth) is giving me 12 always instead of 5
i tried if( Year= year(today()), SubField(today(),'/',1),12) which is working on sample data but not working on real data , it looks like condition Year= year(today()) being ignored always and this formula giving me always 12 result
attached is sample data
dimension used in chart is YTDComparison
you can see value 3 which is incorrect , it should be 5