Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Time to share some sample data with expected output?
May be this
=RangeMax(0, Sum({<VER = {"OPEN", "ACT"}>}EPRC) - Sum({<VER = {"PLAN"}>}EPRC))
What are you getting when you use this alone?
(sum({<VER={"OPEN"}>}EPRC) + sum({<VER={"ACT"}>}EPRC)) - sum({<VER={"OPEN"}>}EPRC)
No, still didn't work
Sample would be helpful as others also mentioned
Ok, I'll give you something soon Sunny.
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))