Announcements
cancel
Showing results for
Did you mean:
Contributor II

## error in the calculated dimension

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)))))))

2 Replies
MVP

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

Partner - Champion III
What error are you getting?
Its hard to help you without knowing how vSelDate and vMaxDate are defined.
A sample would help.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser