Calculated Column and Filter Issue

hs219 — Sat, 16 Nov 2024 20:52:49 GMT

Hi!

I have a question about a issue in a calculated column and filter.

I've created a formula that return the values correctly.

When I put this same formula in a calculated column in the pivot, it returns the correct values.

But when I have a filter with this same calculation and then filter the data, the pivot returns me the wrong values.

Can you help, please?

Thanks.

The formula used for calculated column in pivot and filter is this one:

=if(not match([FIELD 1],'STRING 1','STRING 2') and [FIELD 2] = '*', 'RESULT 1',

if(WildMatch([FIELD 1],'STRING 1','STRING 2') and not match([FIELD 2],'STRING 4','STRING 3','STRING 5'),'RESULT 1',

if(WildMatch([FIELD 1],'STRING 1') and WildMatch([FIELD 2],'STRING 6'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 1') and WildMatch([FIELD 2],'STRING 5'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 2') and WildMatch([FIELD 2],'STRING 6'),'RESULT 2',

if(WildMatch([FIELD 1],'STRING 2') and WildMatch([FIELD 2],'STRING 5'),'RESULT 2',

if(IsNull([FIELD 2])=1,'RESULT 1',

if(len([FIELD 2])=0, 'RESULT 1',
if([FIELD 1]='*' and [FIELD 2] ='*', 'RESULT 1','RESULT 1')))))))))

Re: Calculated Column and Filter Issue

dplr-rn — Mon, 13 May 2019 16:13:04 GMT

i would suggest doing this calculation in the load script and create a column. Use that column in your table and filter

hs219 — Mon, 13 May 2019 16:29:53 GMT

Is not possible to do in that way because the columns are from different tables and isn't possible to join them on script.