Hi
In my report i have a condition for one of the data item(Date) like product type in('a','b','c') the min(ac start date) for product id else min(ac pl start date for prod id)
For above expression i am getting the min ac start date(01-01-1985) for one of the product type
By using above condition i need to display the region like 'US','UK' and 'JAPAN',suppose the above product types one of the product type min ac start date is='01-01-1985' so that i need to display US like that(Based on the date i need to display the region in another column)
thanks
Create two calculation
1] one calculate your date part product type in('a','b','c') the min(ac start date) for product id else min(ac pl start date for prod id)
For above expression i am getting the min ac start date(01-01-1985)
2] use the above calculation to calculate the country part
if(calculated_date ='01-01-1985') then
('US')
else if(calculated_date ='01-01-1999') then
('UK')
else
('JAPAN')
Hi HalfBloodPrince,
Thanks for your response,
How to pass the date field without hardcoding the dates to second calculation?
Thanks