Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to create a report that prints out the previous 12 months. I have a dimension of
plan_desc_nm
and also
prod_dt
with an expession of
sum({$<Year=,Month=,Week=,Date=,%Date=,prod_dt=,[Month Year]=,MonthNo=,YearMonthNo=,YearMonthSeq={"<=$(=max(YearMonthSeq)) >=$(=max(YearMonthSeq)-12)"}, MonthEndFlag={1} >} mtd_avg_bal_amt).
I am trying to get it to print out the balances of each plan desc name base on the prod_dt. Currently the MonthEndFlag is not working correctly because I do not have prod_dts from sundays(jan and april 2015, month end falls on a sunday, which i dont have those balances of.)
I do have a field called PrevMonthEnd which does have the correct dates (Jan 30th(saturday) vs jan 31st(sunday) and the same deal with april)
Ideally i would like it to say in the expression PrevMonthEnd=prod_dt rather MonthEndFlag={1}.
Is there any solution to help fix this? Thanks
Do you have a sample you can share with your expected output?
here is a picture of the current Table. It prints out everything correctly but no May/January since the MonthEndFlag is not equal to 1. I just need to get the May and January column in the table somehow.