Set analysis sum between two given dates

[harleen_singh]

Hello,

             i want to calculate sum between two given dates using set analysis. I am want to use greater than or equal to startdate and less than or equal to Enddate.

I am using this formula. but its not working even for 1 condition. How to use less than or equal to condition in ths formula??/

sum({$<OrderDate>={StartDate}>} Netamountpaid )

thanks

Lavi

[Anonymous]

@Stefan Wühl

please help

[passionate]

Hi,

Usually in this kind of scenario for start and end date we go with Variable trigger.

For start and end date.

Regards,

Pankaj

[bvssudhakar]

Hi Stefan,

I have some queries and i have posted in community also but no one are responding to my queries.

Can you help me for this query..:=Sum({<Floor(Today()-30)-Floor([Closed date])>}[No. of CV Submitted])

I wrote this expression for bar chart but it is giving error

My requirement is i want to calculate date difference from closed date to last 30 days for resumes submitted column

Please help me out from this

Thank you in advance

[steve1982]

Hi Stefan,

If the startDate and EndDate as the dimensions in a table, which mean each rows contain different StratDate and EndDate, how this this can be done on set analysis?

Thanks
Steve