Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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
Proud to be a Super User!
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
Proud to be a Super User!
User | Count |
---|---|
94 | |
86 | |
78 | |
68 | |
63 |
User | Count |
---|---|
113 | |
99 | |
97 | |
64 | |
59 |