error in the calculated dimension

[manjunaths]

Hi All,

I am getting error in the following calculated dimension. Need help to resolve.

In the following dimension,

B1=45

B2=90

B3=120

B4=180

B5=360

=if((($(vSelDate)-$(vMaxDate))>=0 AND ($(vSelDate)-$(vMaxDate))<=$(vB1)),'Range 1 : 0 - ' & $(vB1),
if((($(vSelDate)-$(vMaxDate))>=$(vB1)+1 AND ($(vSelDate)-$(vMaxDate))<=$(vB2)),'Range 2 : ' & ($(vB1)+1) & ' - ' & $(vB2),
if((($(vSelDate)-$(vMaxDate))>=$(vB2)+1 AND ($(vSelDate)-$(vMaxDate))<=$(vB3)),'Range 3 : ' & ($(vB2)+1) & ' - ' & $(vB3),
if((($(vSelDate)-$(vMaxDate))>=$(vB3)+1 AND ($(vSelDate)-$(vMaxDate))<=$(vB4)),'Range 4 : ' & ($(vB3)+1) & ' - ' & $(vB4),
if((($(vSelDate)-$(vMaxDate))>=$(vB4)+1 AND ($(vSelDate)-$(vMaxDate))<=$(vB5)),'Range 5 : ' & ($(vB4)+1) & ' - ' & $(vB5),
if((($(vSelDate)-$(vMaxDate))>=$(vB5)+1),'Range 6 : ' & '> ' & ($(vB5)+1)))))))

[tresesco]

It would be easier for us to debug if you could share your app with sample data (if data security is a concern).

[jonathandienst]

What error are you getting?
Its hard to help you without knowing how vSelDate and vMaxDate are defined.
A sample would help.