Set expression

[#1]

Not reading properly please help on below expression

Dimensions> target date,com-code

Sum({<DATE={'$(=Addmonths (DATE,1))'>}sales)

[PrashantSangle]

Hi,

What are trying to achieve? might be date format is change after applying addmonths().

try like

Sum({<DATE={'$(=date(Addmonths(DATE,1),'YourDateFormat'))'>}sales)

Regards,

Prashant

[yasmeenk]

Hi,

What is your exact need?

[sunny_talwar]

I would suggest double quotes for outer single quotes

Sum({<DATE={"$(=Date(Addmonths(Max(DATE), 1), 'YourDateFormat'))"}>}sales)

But this still might not work because you havn't provided the context of what you are trying to do here?

[#5]

Am trying to get for next month no of employees

which is DOJ>TARGET DATE

I have created flag

If(DOJ>Target date,1,0) as flag1

In expression > sum ({<flag={1},......>.}employees)

Any suggestions??

[sunny_talwar]

So what is DATE here?

[#7]

Based on the DOJ here I mentioned only doj

Sum({<flag1={'1'},DOJ={"$()"}>}reqd employee)

Pls help

[sunny_talwar]

Can you provide few rows of sample data and explain the desired output based on your sample?

[#9]

To make a report by using these dimensions

Requisition number,

Requisition date,

Target date,

And expression which I have explained.

[sunny_talwar]

How to get answers to your post?