Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Problem regarding Set Analysis

Dear All,

Can any one please help me in regarding set analysis.

I am having a expression using if Condition as:

If(Date_Master>=Min_Date and Date_Master<=Max_Date,Sales)

I want to make this expression using Set Analysis.

Please Help me to write a expression using Set Analysis.

Waiting for reply,

Regards,

Pranav

4 Replies
lironbaram
Partner - Master III
Partner - Master III

sum({<Date_Master={">=$(#Min_Date)  <=$(#Max_Date)"}>}Sales)

Not applicable
Author

Dear baram,

Thanks for your reply, but the expression send by you doesnt work properly it shows all the value in 0.

Please Check and give a correct answer.

Regards,

Pranav

jagannalla
Partner - Specialist III
Partner - Specialist III

=(Sum({$<Date_Master={">$(Min_Date)<=$(Max_Date)"}>} Sales))

Try this it may helps you...

jagannalla
Partner - Specialist III
Partner - Specialist III

Pranav,

Do you got the solution?