Skip to Content
0

Formula based on matching and unmatching Dimension

Oct 25, 2017 at 09:56 AM

38

avatar image
Former Member

Hi,

I am struggling with this for last one week. can anyone help me

I have 2 data providers Q1 contain Material and Q2 contains ISBN. I am merging both at report level.

(Material and ISBN is list of numbers and both are string)

eg

Material ISBN Formual 111 111 A 121 122 B 123 124 C

Now I want to write a formula based on that saying that

if (Material =ISBN Then “A” (Eg:111)) ElseIf (if the number only in Material then “B”(eg. 121,123) Else (IF the number only in ISBN then “C”(eg.122,124 )))

anyobe have solution to this approcej

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

AMIT KUMAR
Nov 10, 2017 at 02:57 PM
0

follow steps mentioned in the attached link to get matched and unmatched.see if it will work for you.

https://blogs.sap.com/2014/12/08/using-merged-dimensions-to-perform-set-operations-union-intersection-and-minus/

Share
10 |10000 characters needed characters left characters exceeded