From IF to Set Analysis (simple)

[anitamelbye]

Hi,

can anyone tell me what I am doing/thinking wrong in this case? I am trying to make a 30-60-90 split on our invoices, sorted by duedate. If i make it with IF's, it works fine, but when trying to write a set analysis, I am obviously doing something wrong.

I thought this

IF(RNREST<>0, IF(DD-RNFDAT<0, RNBELØ,0))

would transfer in to this:

SUM ({<RNREST= {'<> 0'}, [DD-RNFDAT]= {'< 0'}>} RNBELØ)

This should be really easy to get to work, right? Anyone..?

*newbee in love*

[anitamelbye]

This actually works..

SUM({< RNREST = {'<>0'}, RNFDAT = {'<$(=date(DD-0))'}, RNFDAT = {'>=$(=date(DD-30))'} >} RNBELO )

*newbee feelin' clever*

[#3]

Hi Anita

After calling me the BEST I had to come up with something.

Needed to create some data first, can you try

SUM({<RNFDAT={'>$(=date(DD-30)) <$(=DD)'}>}RNBELO)

Maybe change > to >= and/or < to <= as of your business rules

Regards

Juerg

[anitamelbye]

Or .. not.. 😞

Jürg..? 🙂

Edit: I just saw your suggestion.. trying now.. ;:-)

[anitamelbye]

You wrote: SUM({<RNFDAT={'>$(=date(DD-30)) <$(=DD)'}>}RNBELO), and it did not work, but when I swiched places to:

SUM({< RNFDAT={'<=$(=Date(DD))>$(=Date(DD-30))'}>} RNBELO ) it worked 🙂 I dont know why, and I really dont care..

Did you hear? it works... YEAH!

THANK YOU Juerg

[#6]

saw it, thanks, so I hope still in love but not a newbee any more, keep qliking!

[#7]

Hi Anita,

You can use somethig like this as dimension

if(num(DueDate)-num(today())<90,Class(num(DueDate)-num(today()),30,'arrears'),'arrears>=90')