Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
Please, it's urgent.
Business Amount |
0-30 |
31-60 |
61-180 |
- |
- |
>540 |
Future |
I have taken nested ifs for dividing the column into different columns in straight table.
If(BusinessAmount=1,’0-30’, If(BusinessAmount=2,’31-60’…. ,If(BusinessAmount=7,’Future’)
Business Amount |
0-30 |
31-60 |
61-180 |
- |
- |
>540 |
It has to show 1st table but it is showing 2nd table i.e. without future value it is showing.
Thanks
Ramesh
please copy/paste in the exact expression you are using. Please also add a screenshot of a list box showing the raw businessamount values ( 1....7) . That should help point us in the right direction
Hi,
Post your complete nested if statement.
Regards