Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i am having month filed like this
month
0
1
2
3
4
5
6
7
8
9
10
11
12
i want to convert this in jan,feb,mar......
so used this Month(MakeDate('2014',monthfield)) as newmonth
its working i used this newmonth field to convert quarter but it is not deriving the quarter. also i used this newmonth filed in chart its not giving the result. if i use old month field its giving desired result
any suggestions plz?
Hi Treseco,
Plz check this chart in sample app
Try expression like:
sum({<ACNT_FLEX_02={'Balance Sheet'},TBAL_Month={'>=$(vTBL_month)'}>}TBAL_MTD_DR_LC_1-TBAL_MTD_CR_LC_1)
hi Tresesco,
i will try and let you know and vTBL_month is variable it contain max(TBAL_Month) is it ok and i need to show last six month value alos
thank you
HI tresesco,
Its Working but problem in Quarter. i can only get Q1 and Q4. sorry for the delay
Thank you