set analysis is not working as expected

Swathi — Fri, 15 Nov 2024 21:06:53 GMT

i have created one inline table and used that to filter table data, based on selection. but output is not coming. i didn't understand why it is not

Inline Table:

Load * Inline [
Volumevscm
<{-30%}and>{30%}
<{-30%}and{10%}-{30%}
<{-30%}and{0%}-{10%}
<{-30%}and{-10%}-{0%}
<{-30%}and{-30%}-{-10%}
<{-30%}and<{-30%}
];

i have created one filter used above inline for filter the data of the table. in the table i wrote to below formula

=Pick(
Match(
GetFieldSelections(
[Volumevscm],
'<{-30%}and>{30%}',
'<{-30%}and{10%}-{30%}',
'<{-30%}and{0%}-{10%}',
'<{-30%}and{-10%}-{0%}',
'<{-30%}and{-30%}-{-10%}',
'<{-30%}and<{-30%}'
),
$(vc1), $(vc2),$(vc3),$(vc4),$(vc5),$(vc5),$(vc6)
)

variables formula in the pick match:

$(vc1)= aggr( if( $(vGrowthrateCm2) > $(vv1) and $(vGrowthrateVolume) < $(vv5), sold_to_desc ), sold_to_desc)

$(vc2)=aggr( if( $(vGrowthrateCm2) >= $(vv2) and $(vGrowthrateCm2) <= $(vv1) and $(vGrowthrateVolume) < $(vv5), sold_to_desc ), sold_to_desc )

$(vc3)= aggr(if($(vGrowthrateCm2) >= $(vv3) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)

$(vc4)=aggr(if($(vGrowthrateCm2) >= $(vv5) and $(vGrowthrateCm2) < $(vv4) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)

$(vc5)=aggr(if($(vGrowthrateCm2) <= $(vv4) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)

$(vc6)= aggr(if($(vGrowthrateCm2) >= $(vv3) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc).

my pick match formula is not giving output. showing '-' Kindly help me to solve the issue.

Re: set analysis is not working as expected

anat — Tue, 16 Jan 2024 13:57:47 GMT

seems close bracket missed for GetFieldSelections function.

=Pick(
Match(
GetFieldSelections(
[Volumevscm]),
'<{-30%}and>{30%}',
'<{-30%}and{10%}-{30%}',
'<{-30%}and{0%}-{10%}',
'<{-30%}and{-10%}-{0%}',
'<{-30%}and{-30%}-{-10%}',
'<{-30%}and<{-30%}'
),
$(vc1), $(vc2),$(vc3),$(vc4),$(vc5),$(vc5),$(vc6)
)

Re: set analysis is not working as expected

Swathi — Tue, 16 Jan 2024 14:20:51 GMT

@anat ,Thanks for the reply, only for $(vc1) output is coming, for remaining is not getting output.

in the variables if i give some text or direct fields, without sum or anything, output is coming, for variables it is not coming. variables is correct, individually when i gave in table it is coming correct. iam not where it is wrong, kindly help me

topic Re: set analysis is not working as expected in App Development

set analysis is not working as expected

Re: set analysis is not working as expected

Re: set analysis is not working as expected