Complex set analysis within a if statement........

[Anonymous]

Hi Guys,

I'm doing a set analysis within an If statement, It works perfect when i select one value from a list box and it shows it perfect in a single row, but when i wanna see all the values, they have the same value as the result.

Any help, top of your head?  I know i'll probable need to show some data and what I've done, I'm working on a dummy data demo.

Thanks

And long time no chat.

[vishsaggi]

Time to share some sample data with expected output?

[sunny_talwar]

May be this

=RangeMax(0, Sum({<VER = {"OPEN", "ACT"}>}EPRC) - Sum({<VER = {"PLAN"}>}EPRC))

[Anil_Babu_Samineni]

What are you getting when you use this alone?

(sum({<VER={"OPEN"}>}EPRC) + sum({<VER={"ACT"}>}EPRC)) - sum({<VER={"OPEN"}>}EPRC)

[Anonymous]

No, still didn't work

[sunny_talwar]

Sample would be helpful as others also mentioned

[Anonymous]

Ok, I'll give you something soon Sunny.

[Anonymous · Accepted solution]

Got it working

=if(num(SUM({<VER={$(vPreviousMonth)},YR={$(vCurrentYear)}>}EPRC)/1000,'#,##0')

-

(sum({<VER={"OPEN"}>}EPRC)/1000

+

sum({<VER={"ACT"}>}EPRC)/1000)<0,0,num(SUM({<VER={$(vPreviousMonth)},YR={$(vCurrentYear)}>}EPRC)/1000,'#,##0')

-

(sum({<VER={"OPEN"}>}EPRC)/1000

+

sum({<VER={"ACT"}>}EPRC)/1000))