Please kindly assist me on the below requirement .

[suvechha_b]

Hi All ,

Please kindly assist me on the below requirement .

For the client id 9206070406081 the SBSA bank has two entries with SBSA_Approved_Indicator 1 .

So, it take SBSA DIC as any one value of DIC. But the SBSA Status is not working as its taking two values. How to take one value i.e and show one.

if the values comes one then its 'A' and if its comes as 0 then its 'D'.

sample model attached.

in some examples , its working while if I select the client ID . I need to show the report without selecting the Client ID ....that means it should work for all .....

Thanks ,

[Anonymous]

Dear Bhadra,

Do you have duplicate values in your DB..?

[sunny_talwar]

This is how your data looks like

LatestForPodium = 1 and LatestForState = 1 doesn't align on a single row for SBSA... also... when LatestForState = 1, Approved_indicator is both 0 and 1...

I am not sure how to read this... can you take a look