Does not fall to next line

[Anonymous]

Hi All

I have one calculated dimension as below

If(SHEET_ID = 'A.7.z' and match(LINE_NUMBER, '13') and match(Lob_ID, '242') and match(SUB_ID, '5'), 'Non-CB&S Central/ GLM'),
If(SHEET_ID = 'A.7.z' and match(LINE_NUMBER, '13') and match(Lob_ID, '242'), 'All CB&S'

In first line it consider only SUB_ID = 5

In second line it should consider all SUB_ID, but it does not.

If I remove first line than I am getting right amount.  What to put in second line so it consider all SUB_ID?

Thanking you all

[Anonymous]

Clik on advanced editor in the top right corner, so you will be able to attach a file ("attach" is the bottom right corner).

[Anonymous]

Sorry to ask, I do not see advance editor icon/option. See the screen attached

Thanks

[Anonymous]

Please, don't worry

Go to the full discussion where our questions/answer are, then reply to a messagge: you will see, as my screenshot shows, (sorry for the italian language...) the advanced editor option.

[Anonymous]

Thanks for walk with me through

I have attached

[Anonymous]

Thank you.

I had a similar problem: I think the issue is due to the fact that the sets of data determined by if statement are not disjoint One is a subset of the other.

A question: do you have only these 4 combinations?

LobID 242 & SubID 5

LobID 242 & All SubID

LobID 310 & SubID 4

LobID 310 & All SubID

If yes, you could create a dimension (with an inline table) with these "labels", then, write an expression (with set analysis) with 4 if statement like this:

if(Dimension='LobID 242 & SubID 5', sum({<LobID={242}, SubID={5}>}Amount),

if(Dimension=  'LobID 242 & All SubID', sum({<LobID={242}, SubID=>}Amount) , .....))))

Please, let me know!!

[Anonymous]

Elena

I have achived by the way you suggested. I applied in SET ANALYSIS, rather than Dimension.

I appreciate your continuous interest and follow up, Thanking you.

Really helpful answer