Forum Discussion
PranavChoudhary
3 years agoQrew Trainee
Hi,
use below code :
If([Penetration Days]<Days(0),"Not Aged",
[Penetration Days]>Days(1),"0-3 M",
[Penetration Days]>Days(91),"4-6 M",
[Penetration Days]>Days(181),"7-9 M",
[Penetration Days]>Days(271),"10-12 M",
[Penetration Days]>Days(366),"13-18 M",
[Penetration Days]>Days(547),"19+ M"
)
You need to remove the comma after text in last line.
------------------------------
Pranav Choudhary
Quickbase Expert Builder Certified by Quickbase
beniwalpranav@gmail.com
------------------------------
use below code :
If([Penetration Days]<Days(0),"Not Aged",
[Penetration Days]>Days(1),"0-3 M",
[Penetration Days]>Days(91),"4-6 M",
[Penetration Days]>Days(181),"7-9 M",
[Penetration Days]>Days(271),"10-12 M",
[Penetration Days]>Days(366),"13-18 M",
[Penetration Days]>Days(547),"19+ M"
)
You need to remove the comma after text in last line.
------------------------------
Pranav Choudhary
Quickbase Expert Builder Certified by Quickbase
beniwalpranav@gmail.com
------------------------------
- MarkShnier__You3 years agoQrew LegendHere is corrected code. as the original code has a logic flaw.
If([Penetration Days]<Days(0),"Not Aged",
[Penetration Days]<=Days(90),"0-3 M",
[Penetration Days]<=Days(180),"4-6 M",
[Penetration Days]<=Days(270),"7-9 M",
[Penetration Days]<=Days(365),"10-12 M",
[Penetration Days]<=Days(547),"13-18 M",
[Penetration Days]>Days(547),"19+ M"
)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Related Content
- 10 months ago
- 2 months ago
- 2 months ago
- 2 months ago