Moving Calculated Dimension to Set Analysis

[aetingu12]

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,

[bramkn]

if one is a num and one is a date this would cause an issue yes. so its best to change this and see if it works.

[aetingu12]

It is strange that is not an issue within the calculated dimension, but in the set analysis.

[bramkn · Accepted solution]

Thats true indeed. I make sure to always use nums to be sure it is going to work. Also make sure there is no time with that date. So always use floor.