Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I am including search option on expression in straight table but values are showing wrong in the table like below
for ex:
Straight table data
Dim1|Dim2|Dim3|Expression-Sum(Sales)
A|B|C|100
A|D|X|3000
G|B|D|40
Z|ZX|C|4000
so here I am searching <3000
Then I am expecting results like
A|B|C|100
A|D|X|3000
G|B|D|40
But I am getting results like below
A|B|C|4100
A|D|X|3000
G|B|D|40
Can some one pls suggest.
-Priya
The value of first row changed to 4100? or is that a typo?
values are changing irrespective of search
for ex if search <3000
and dimensions are picking and according to dimension availablity values are coming in expression
Would you be able to share a sample to show the problem
Can you please share the sample app.
I don't have exact application and issue, but in my sample data it is showing kind of issues.
for ex I am searching <10 then I am expecting -1 value also.
This is the only one I have issue in sample data but with actual data values are also showing incorrect as said before
if you search like <20 then you are getting 3001, -1
Hi Priya,
Do like this
add recno() as a dimension you will get correct result/
T1:
LOAD
recn0() as Rec,
Dim1,
Dim2,
Dim3,
Sales
FROM
[data.xlsx]
(ooxml, embedded labels, table is Sheet1);
Here in your 3 dimension records are same for some records ,that's why it taking sum of both records .
Seems like the issue is related to nulls in your dimension... try this
NULLASVALUE *;
Set NullValue = 'NULL';
LOAD Dim1,
Dim2,
Dim3,
Sales
FROM
[data.xlsx]
(ooxml, embedded labels, table is Sheet1);
And then try the search