To Bifurcate the values present in a column based on difference of numeric values.

[HiShilpiRanjan]

Hi All,

We have a Requirement in Webi Report:

There are two columns called Tax String(1) and Tax String(2) and third column "Overall Difference" in the Webi  report. The Tax_String has different Tax codes and their numeric values.
The requirement is to get each Tax code in separate columns when there is difference in their numeric values.
The green columns below, need to be created. We have just first 3 columns in the report.
snippet below:

The two columns can have different Tax_string values. Above snippet contain just one example.
Snippet below for more examples:

Request you to suggest.

Thanks in advance..

Regards,
Shilpi

[nachtaktiv]

You have to split every part of your tax-string1 and tax-string2 into separate elements, with substr(), pos(), lenght()
(e.g. with variables like this: https://community.sap.com/t5/technology-q-a/need-to-split-string/qaq-p/9344510) 

... so it will be easy to compare/calculate every element of string1 and string2  

[HiShilpiRanjan]

Thank-you for this however not able to reach to solution yet, there is still some challenge.
Please find the snippet below:

As the value and length of Tax_String changes, the variable is not giving correct result for all the Tax_String values.
If u see the third row above, I am not getting Tax_Code3_Value. Similarly we have different lengths of values for Tax_String.

Is there any way you can help.

What I was thinking is to apply IF condition on the number of commas in Tax_String for all my headers, however not able to find that how to count the number of commas in the Tax_String.
Is there any way to count the number of specific character in a string in Webi.

Thank-you in advance

[HiShilpiRanjan]

I am able to Bifurcate the string based on the link: