How to show difference between two date fields

[ravikumar_iyana]

Hi,

I have a two fields NR, IRB.

1. NR>30 DAYS to IRB Date ,   required result:Processing, Late Payment.
2. NR<30 DAYS to IRB Date ,   required result: on time payment.
3. when  to IRB Date is value: '-' ,    required result: Processing.
4. NR we will calculate based on system date required, entered more than system date required result: entered wrong date.

note: I required all these expressions in set analysis only.

1. I'm tried for this :

If([IRB] = '-', 'Processing',

     If([IRB]- [PaymentDate NR] < 30, 'On Time Payment', 'Late Payment'))

** i want to convert if() into set analysis**

NR	IRB
10-Jan-17	13-Jan-17
26-Jan-17	02-Feb-17
31-jan-17	10-feb-17
20-feb-17	5-apr-17
5-feb-17	-
10-mar-17	5-jun-17
5-apr-17	-

Advance Thanks,

Ravi.

[zebhashmi]

i think

if (IRB-NR>30,Late Payment,time payment)

[ravikumar_iyana]

Hi,

I want to satisfy all 4 conditions in one expression.

[Qrishna]

Check this out. !

[ravikumar_iyana]

Hi Required all those expressions in Set analysis only.

[Qrishna]

Use NR and IRB as dimensions.

Measure:

=If((if(IRB = '-',0, NUm(Date#(IRB,'DD-MMM-YYYY')))- NUm(Date#(NR,'DD-MMM-YYYY')))>30, 'Processing,Late Payment',

   If((if(IRB = '-',0, NUm(Date#(IRB,'DD-MMM-YYYY')))- NUm(Date#(NR,'DD-MMM-YYYY')))>0 and

      (if(IRB = '-',0, NUm(Date#(IRB,'DD-MMM-YYYY')))- NUm(Date#(NR,'DD-MMM-YYYY')))< 30 , 'on time payment',

      If((if(IRB = '-',0, NUm(Date#(IRB,'DD-MMM-YYYY')))- NUm(Date#(NR,'DD-MMM-YYYY')))<0, 'Processing')))

check attached.

[ravikumar_iyana]

Hi,

you can please help me.

I required all if()expressions into set analysis only.

Thanks,

Ravi.

[Qrishna]

Just wondering if you want the result or set expression.

If you want to write this into set expression then you have to have all the text values pre-defined.

[Qrishna]

And set expression is mainly for defining sets,and its not used to pre define text values like what you do with if() and pick() expressions.