Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a question,
i have a set analysis like this
=Sum({$<Filter={"$(vFilter)"}>} Data)
vFilter value has format data like this
ex : A_B_C_D
I want to get only A_B_C and cut the D.
So the set analysis will be like this :
=Sum({$<Filter={"A_B_C"}>} Data)
Is it possible to make it ?
Thanks
Hi,
Is the format & characters count is fixed all the time?
try this -
=Sum({$<Filter={"$(=left($(vFilter),5))"}>} Data)
left('A_B_C_D',Index('A_B_C_D','_',-1)-1)
Also Try like this:
Put below expression In variable:
=Replace(Filter,'A_B_C_D','A_B_C')
subfield(filter,'_',3)as new_filter
=Left('A_B_C_D',5)