Global Client Filter Across Multiple Database Views

Question

3votes

Can anyone tell me why this formula returns: Too few arguments in function if

Asked Dec 27, 2022
2948 Views
1 Answers
Open

if(prop("Retention") == "<50%", dateAdd(prop("Last Revision"), 1, "days"), if(prop("Retention") == "70%", dateAdd( prop("Last Revision"), 7, "days", if prop("Retention") == "90%", dateAdd(prop(Last Revision), 14, "days"), dateAdd(prop("Last Revision "), 0, "days"))))

asked Dec 27, 2022 by renepereira102 (150 points)

adam · Answer 1 · 2022-12-28T23:59:45+0000

2votes

adam Points1460

this line is missing a ')'

if(prop("Retention") == "70%", dateAdd( prop("Last Revision"), 7, "days", if

should be this:

if(prop("Retention") == "70%", dateAdd(prop("Last Revision"), 7, "days"), if

answered Dec 28, 2022 by adam (1.5k points)

Can anyone tell me why this formula returns: Too few arguments in function if

Please log in or register to add a comment.

1 Answer

Please log in or register to add a comment.

Please log in or register to answer this question.

Recent Activities

blackcrow asked 3 days ago

benarik answered Aug 27

benarik answered Aug 27

benarik answered Aug 27

benarik answered Aug 26

Tags

Can anyone tell me why this formula returns: Too few arguments in function if

Please log in or register to add a comment.

1 Answer

Please log in or register to add a comment.

Please log in or register to answer this question.

Related questions

Without Answer

Recent Activities

blackcrow asked 3 days ago

benarik answered Aug 27

benarik answered Aug 27

benarik answered Aug 27

benarik answered Aug 26

Tags

Connect