Selection of field with If condition

[#1]

Hi All

I want to pick one value in negative using set analysis with this condition where

CBSDesc = 'TRANSFER OF FUNDS #239983'

CBSAmount<1

then I want the result. This condition is not working in KPI

IF(CBSDesc = 'TRANSFER OF FUNDS #239983' AND CBSAmount<1, sum({$<CBSDesc = {'TRANSFER OF FUNDS #239983'}, 0)

Could you please help with this.

[jagan]

HI,

Try like this

=Max({<CBSDesc = {'TRANSFER OF FUNDS #239983'}, CBSAmount={'<0'}>} SomeFieldName)

Note: Replace SomeFieldName with your actual field name.

REgards,

jagan.

[reddy-s]

Hi Renu,

As Jagan suggest a set analysis statement should help you solve the issue. Also this document should help you understand the statement.

A Primer on Set Analysis

Thanks,

Sangram.

[#4]

Thanks Jagan for your kind help, this worked...

[#5]

Thanks Sangram for sharing this document...

[jagan]

Hi,

If you got the answer please close this thread by giving Correct and Helpful Answers to the posts which helps you in getting the answers.

Regards,

jagan.

[jagan]

Hi Renu,

Please close this thread by giving Correct Answer to the post which helps you.

Regards,

jagan.

[reddy-s]

Always Welcome!

[#9]

hi i need if condition to select fields that is if two coloumns are having some datas so i need to add one coloumn data into other coloumn data.

[reddy-s]

Hi Pramod,

Try this:

if(columnA = Column B, calumnA & ' ' & ColumnB) as fieldname

Thanks,

Sangram.