Question in Multi-Row Formula

[Mostafa_Anwar]

Hello All,

Attached is my dataset, I want to use use formula in Multi-Row Formula stating that in case of the the value beside PO = NO and the value beside Invoice = Yes OR the value beside PO = Yes and the value beside Invoice = No then replace value NO with Yes only and in case of the value beside PO = NO and the value beside Invoice = No no change will happen. 

So how to do this, i have tried several times but the result i got changed all values to be Yes.

Thanks in advance

[Thableaus · Accepted solution]

Hi @Mostafa_Anwar

I added a new container to do this simple change you needed it. WF appended.

See if it suits you.

Cheers,

[Mostafa_Anwar]

The provided WF changed any NO values whether beside SECB or SFDA approvals but i was looking for another condition as per the details below,

In case of Value called SECB Approval :NA then the Value beside SECB Approval to be change from NO to be NA

Also In case of Value called SFDA Approval :NA then the Value beside SFDA Approval to be change from NO to be NA

Please use the attached modified dataset.

Many thanks

[Mostafa_Anwar]

Hi Thableaus, Do you need more clarification or my question above clear?

Thanks in advance. 

[Thableaus]

@Mostafa_Anwar

I'm gonna check it better later, as it needs some changes in the WF. Everytime fields keep getting added and are also changing.

Also, please enable private messages in your profile settings so I can message you and we can discuss the details in a faster way.

Cheers,

[Mostafa_Anwar]

Thanks for your respond, Unfortunately the private messages disabled because this feature is only available to users who've ranked up to Matter status and i am still new in this space!

Take your time whenever you done pls do let me know.

Thanks.

[Thableaus]

@Mostafa_Anwar

Solution appended.

Please mark the 3 posts with WF's I provided you in each step as solved, as each one took a lot of work, if you don't mind.

Cheers,

[Mostafa_Anwar]

The provided WF for something different but i was looking for WF as per the details below,

In case of Value called SECB Approval :NA then the Value beside SECB Approval to be change from NO to be NA

Also In case of Value called SFDA Approval :NA then the Value beside SFDA Approval to be change from NO to be NA

Dataset provided Thursday.

Thanks in advance.

[Thableaus · Accepted solution]

Hi @Mostafa_Anwar

I totally messed up and uploaded the wrong WF.

Please check this one, which should be the one that I had done before.

Cheers,

[Mostafa_Anwar]

Thanks a lot, Truly appreciated,