topic Re: IF condition not working properly in App Development

IF condition not working properly

P_Kale — Fri, 05 Jan 2024 07:45:21 GMT

Hi,

In data, under INTERACTIONTYPE column we have 'Request' and blank. But below given IF condition is not giving proper out-put. Only 1 condition is working where ever details are found but, where ever details are blank condition is not working. I have tried it both this way but it is not working.

if(INTERACTIONTYPE <> 'Request','Request_Not_Rceived','Request_Received') as REQUEST_RECEIVED_NOT

if(Len(INTERACTIONTYPE)>5,'Request_Rceived','Request_Not_Received') as REQUEST_RECEIVED_NOT_1

Can you pl help.

Thanks in advance

Re: IF condition not working properly

steeefan — Fri, 05 Jan 2024 07:56:57 GMT

Some ideas w/o knowledge about the content of the field in question:

// Flip condition if(INTERACTIONTYPE = 'Request','Request_Rceived','Request_Not_Received') as REQUEST_RECEIVED_NOT // Create a flag Not(INTERACTIONTYPE = 'Request') AS REQUEST_RECEIVED_NOT // Extend condition if(INTERACTIONTYPE <> 'Request' OR Trim(INTERACTIONTYPE) = '' OR IsNull(INTERACTIONTYPE),'Request_Not_Rceived','Request_Received') as REQUEST_RECEIVED_NOT

Re: IF condition not working properly

P_Kale — Fri, 05 Jan 2024 08:14:37 GMT

Hi Thanks,

I Have tried in all the 3 ways but it is not working. I unable to understand why formula not able to pick Blank in the column. In excel while exporting I am getting "-" in place of Blank. I have tried by setting condition = '-' too but still it is not working,

Re: IF condition not working properly

steeefan — Fri, 05 Jan 2024 08:24:43 GMT

"-" is just the representation of a blank or NULL value in a table chart object. It's most likely not the actual value present in your data.

Can you post a snippet of your data, ideally as a file, containing various values for INTERACTIONTYPE?

Re: IF condition not working properly

P_Kale — Fri, 05 Jan 2024 09:58:16 GMT

Hi,

Thanks. While explaining the scenario I came to know what Mistake I am doing which I have reified.

Now I am getting desired output.