Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
sum({<Date_Master={">=$(#Min_Date) <=$(#Max_Date)"}>}Sales)
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
=(Sum({$<Date_Master={">$(Min_Date)<=$(Max_Date)"}>} Sales))
Try this it may helps you...
Pranav,
Do you got the solution?