Skip to main content
Solved

Filter data with formula

  • July 18, 2022
  • 4 replies
  • 848 views

Forum|alt.badge.img

Hi, good afternoon everyone!

I have an error and I can't solve it, could you help me with the solution, please?

I have the formula: 'Bonus per year (euros)'[BY CONSTANT: Month.Year][FILTER: Month.'Month
of Year'='Month of Year'."December"]

I got error return: " Error: Unknown List Property: Month.'Month
of Year' "

But when I go to check the Month dimension, I see the list.

Can you help me please?

Thanks!

Best answer by Nathan

Hi,

 

when I copy this string: Month.'Month
of Year'='Month of Year'."December"
into Pigment, I get an error.
You have a hidden character that makes a line break. Try to retype it or copy this:

Month.'Month of Year'='Month of Year'."December"

4 replies

Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • Answer
  • July 18, 2022

Hi,

 

when I copy this string: Month.'Month
of Year'='Month of Year'."December"
into Pigment, I get an error.
You have a hidden character that makes a line break. Try to retype it or copy this:

Month.'Month of Year'='Month of Year'."December"


Forum|alt.badge.img
  • Author
  • Apprentice Author
  • July 18, 2022

'Bonus per year (euros)'[BY CONSTANT: Month.Year][FILTER: Month.'Month
of Year'='Month of Year'."December"]

I put this formula but it still gives error so checked the month dimension and the list exists there.

But the error persists.

Thanks!


Nathan
Employee
Forum|alt.badge.img+12
  • Employee
  • July 18, 2022

that was just a copy of yours. Try the updated one I shared


Forum|alt.badge.img
  • Author
  • Apprentice Author
  • July 18, 2022

Hi,

 

when I copy this string: Month.'Month
of Year'='Month of Year'."December"
into Pigment, I get an error.
You have a hidden character that makes a line break. Try to retype it or copy this:

Month.'Month of Year'='Month of Year'."December"

Hi Nathan!

I think it was the copy and paste of the course pdf.

Thank you very much!

Have a good day