Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
that is my table:
I need to obtain the total I've put in field "R_T" as follows:
If(COD=9937199,Sum({<COD={9937199},TIME=>}AD)-vSumT9937302,
if(COD=9937072,Sum({<COD={9937072},TIME=>}IN),Sum({<TIME=>}AD)))
And R:
If(COD=9937199,Sum({<COD={9937199}>}AD)-vSum9937302,
if(COD=9937072,sum(IN),sum(AD)))
My variable:
vSumT9937302=Sum({<COD={9937302},TIME=>}AD)
vSum9937302=Sum({<COD={9937302}>}AD)
In R gets all filters and R_T not take the filter TIME because I want the total always displayed.
The problem is that when a COD does not have data in TIME, in this case, COD 9937072 does not have data in TIME "3" so when I filter TIME 3 does not give the total correctly.
How I can fix that? I want to see total every time
I attached file. Thanks!!
Hi!
I fixed it. See expression R_T2
Hi! thanks!
And if the COD of the variable has the same situation:
What is the code for the variable vSumT9937302 to show always the total?
Thank you!
As I see we exclude TIME in the Set Analysis. So vSumT9937302 always ignores selection on TIME.
Or I didn't get your question...
You're right! Everything it's ok.
Thank you very much!