Announcements
cancel
Showing results for
Did you mean:
Not applicable

## problem with \$(=maxdate-30) in set analysis

Hi,

My expression \$(maxdate) -30 gives me the date that is 30 days less than the max date. However If I put my expression like

\$(=date(maxdate - 30)), it gives me -2015

for some reasons, the dollar sign expansion is making some problem that I dont understand. In my set analysis, I want to set my expression like

```sum({<DATE_POS = {">=(date(DATE_POS - 30))"}>}Profit)
```

However, it does not seem to work. Can someone please explain what is wrong with my dollar sign expansion expression

Arif

7 Replies
Creator II

Hello,

I would try this:sum({<DATE_POS = {">=\$(date(DATE_POS - 30))"}>}Profit)

Rogério.

Anonymous
Not applicable
Author

This approach always works for me:

sum({<DATE_POS = {"\$(='>=' & date(MaxDate-30))"}>} Profit)

Not applicable
Author

hi,

Try like this....

sum({<DATE_POS = {"\$(>= & date(MaxDate-30))"}>} Profit)

Not applicable
Author

I have changed the expression a little but neither of them work

```sum({<CurYTDFlag = {1}, Month={"\$( = & month(max(DATE_POS)))"}>}Profit)
```

and

```sum({<CurYTDFlag = {1}, Month={"\$( = month(max(DATE_POS)))"}>}Profit)
```
Anonymous
Not applicable
Author

(Apparently you never tried my suggestion above.)

After you've changed your logic - your second version is technically correct, and should work.  The reasons that it not working may be:

- CurYTDFlag does not have value 1

- values in the Month field are not the same as the function month(max(DATE_POS)) returns.

Not applicable
Author

Thanks for your answer. Your suggestions seems to work with dates but I cannot get it working with the month expression. I tried it like this

```=sum({<Month = {"\$(='=' & month(MaxDate-30))"}>} Profit)
```

However, it does not seem to work. I have also removed the CurYTDFlag. Also, both the Month field and the expression seems to be returning mar. The only problem again is with the dollar sign expansion.

If I try it in a text box

```=month(max(DATE_POS))
```

it returns mar as a value. However, If try

```=\$(=month(max(DATE_POS)))
```

It returns nothing

Anonymous
Not applicable
Author

Typically I test expressions in text boxes as well, but not the \$-sign expressions like this

=\$(=month(max(DATE_POS)))

But I did test this, and it worked:

=sum({<Date=, MonthName = {"\$(=month(max(Date)))"}>} Sales)

And it works fine.  Field names differs from yours, I have MonthName with values 'Jan' to 'Dec'.  And, the "Date=" was necessary because I selected Date and didn't want it to affect the result, just wanted to define the Month by that selection.

Community Browser