Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
All,
I have a calculated dimension as such :
=if(MATURITY_DATE >= MonthStart(SUMMARY_DATE) and MATURITY_DATE <= SUMMARY_DATE,'Matured','')
and a expression as:
sum({$<SUMMARY_DATE = ,UK = {'N'}, FRUIT = {' '}>} PRICE)/-1000000
This gives me what I want which is what portion of my produce has matured. I need to move the calculated dimension in to my expression due to the way I need to report (I have created a list of values with ValueList('Total','Maturites'))
When I move my calculated field on to my expression as:
sum({$<SUMMARY_DATE = ,UK= {'N'}, FRUIT = {' '},MATURITY_DATE = {">=$(SUMMARY_DATE)<$(SUMMARY_DATE)"}>} PRICE)/-1000000
It doesn't seem to give me what I want. Maturity date is in number format, Summary date is in date. I wonder if that is the reason.
Any help is more than appreciated.
Thanks,