Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have 3 options in this post, 2 works as expected and 1 does not.
1) THIS WORKS AND DOES NOT RESPECT THE FILTER APPLIED BY THE USER (OK ITS IS CORRECT)
In the graph:
sum(
{1}
if(
([Rev Prc - Rms Envia]=0 and round([Rev Prc - Mrg Real Var],0.01)<round([Rev Prc - Mrg Cad Var],0.01))
,1,0 )
)
2) THIS WORKS DOES NOT RESPECT THE FILTER APPLIED BY THE USER (OK ITS IS CORRECT)
In the graph:
count(
{1<
[Rev Prc - Rms Envia]={0}
,Rev Prc - Mrg Real Var] = {"<[Rev Prc - Mrg Cad Var]"}
>}
[Rev Prc - RowID]
)
Round In the editor:
num([Rev Prc - Mrg Real Var],'#.00') as "Rev Prc - Mrg Real Var",
num([Rev Prc - Mrg Cad Var],'#.00') as "Rev Prc - Mrg Cad Var",
3) THIS WORKS TO COUNT CORRECTLY EXCEPT IT DOES RESPECT THE FILTER APPLIED BY THE USER (SHOULD NOT)
count(
{1<
[Rev Prc - Rms Envia]={0}
,[Rev Prc - RowID] = {"=round([Rev Prc - Mrg Real Var],0.01)<round([Rev Prc - Mrg Cad Var],0.01)"}
>}
[Rev Prc - RowID]
)
The problem with the filter is in this line
,[Rev Prc - RowID] = {"=round([Rev Prc - Mrg Real Var],0.01)<round([Rev Prc - Mrg Cad Var],0.01)"}
But it does work and count correctly.
I would like to know if there is a way to do it using the option 3.
Option 1 ok.
Option 2 ok. but I need to create more columns in the editor.
Option 3 works but does respect the filter (should not).
Thanks!
Bruno
May be try this
Count({1<[Rev Prc - Rms Envia] = {0}, [Rev Prc - RowID] = {"=Only({1} Round([Rev Prc - Mrg Real Var], 0.01) < Round([Rev Prc - Mrg Cad Var], 0.01))"}>} [Rev Prc - RowID])
May be try this
Count({1<[Rev Prc - Rms Envia] = {0}, [Rev Prc - RowID] = {"=Only({1} Round([Rev Prc - Mrg Real Var], 0.01) < Round([Rev Prc - Mrg Cad Var], 0.01))"}>} [Rev Prc - RowID])
It worked sunny_talwar!!
Thank you!!
Bruno