Set Analysis Query

[#1]

Hi Friends,

Please let me know if i can write the Set Analysis for the below code. If so any help on the script.

Question No 1

1 .if(x=0),'Yes','NO').

2. if(x=0 and y=1 , zx-1 ,0)

3. if(x>0 and y<>o or x1=0, Zx-1,0)

Here x,x1,y,z, are the variables.

________________________________________________________________________________

Question No 2

=num(sum(if(date<=enddate and((line=('other') and len(override)=0) or (override= 'other')), (AMountx-1),0))+0,'###,###,(###,###);')

__________________________________________________________________________

Regards,

Pooja.

[sunny_talwar]

I don't think Question No 1 can be converted to set analysis, unless I am missing something here.

Question No 2

Can be converted to set analysis, but it would be helpful to look at your data model before we propose anything.

[#3]

Perhaps using your IF logic in the backend script could solve your problem for the first question.

Try this for Question2:

Sum({$<override={'other'},line={'other'},date = {"<=only(enddate)"}>}AMountx-1)

[#4]

Hi Sunny,

Thanks for your response and i guessed the same for Question 1. I have one more doubt that, can we do this by using 'only' function.?

For question no 2  I I will prepare the data modeling.

Regards,

Pooja

[#5]

Thanks Pravesh, Will check.