Forum Discussion
Days going into the wrong buckets
l all,
I have been bumping my head into the wall all day trying to figure out this formula and why it's not working.
I have this formula:
Nol to pay buckets - case2 = IF([NOL to Payment]<=1,"Same Day",IF([NOL to Payment]>1 && [NOL to Payment] <=7,"1-7", IF([NOL to Payment] >7 && [NOL to Payment]<=10,"7 -10 Days",IF([NOL to Payment]>10 && [NOL to Payment] <=18, "10-18 Days",">10"))))
Can you please advise?
Thank you,
M
Hi mluanacruz
How are you calculating your [NOL to Payment] measure? Please provide the code.
With the sample data I set up and this measure
Nol to pay buckets = SWITCH( TRUE(), ISBLANK([NOL_to_Payment]), BLANK(), [NOL_to_Payment]<=1,"Same Day", [NOL_to_Payment]>1 && [NOL_to_Payment] <=7,"1-7", [NOL_to_Payment] >7 && [NOL_to_Payment]<=10,"7 -10 Days", [NOL_to_Payment]>10 && [NOL_to_Payment] <=18, "10-18 Days", ">10")Things seem to work correctly
Regards
Phil
1 Reply
Hi mluanacruz
How are you calculating your [NOL to Payment] measure? Please provide the code.
With the sample data I set up and this measure
Nol to pay buckets = SWITCH( TRUE(), ISBLANK([NOL_to_Payment]), BLANK(), [NOL_to_Payment]<=1,"Same Day", [NOL_to_Payment]>1 && [NOL_to_Payment] <=7,"1-7", [NOL_to_Payment] >7 && [NOL_to_Payment]<=10,"7 -10 Days", [NOL_to_Payment]>10 && [NOL_to_Payment] <=18, "10-18 Days", ">10")Things seem to work correctly
Regards
Phil