Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
HI,
Try like this
=Max({<CBSDesc = {'TRANSFER OF FUNDS #239983'}, CBSAmount={'<0'}>} SomeFieldName)
Note: Replace SomeFieldName with your actual field name.
REgards,
jagan.
Hi Renu,
As Jagan suggest a set analysis statement should help you solve the issue. Also this document should help you understand the statement.
Thanks,
Sangram.
Thanks Jagan for your kind help, this worked...
Thanks Sangram for sharing this document...
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.
Hi Renu,
Please close this thread by giving Correct Answer to the post which helps you.
Regards,
jagan.
Always Welcome!
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.
Hi Pramod,
Try this:
if(columnA = Column B, calumnA & ' ' & ColumnB) as fieldname
Thanks,
Sangram.