Skip to main content
Solved

YTD column

  • July 20, 2023
  • 3 replies
  • 686 views

Forum|alt.badge.img

Hi!

I’m trying to create a new column with YTD figures in a table where we see EBITDA by market.
The logic we’re trying to find is to be able to tell Pigment that this column has to be the sum of the actual months and to group it all in a single column.  That is to say, it would be something similar to a filtering option, just as we can filter by month to see the info for a specific month, so that we can choose to see only the YTD figures.
The idea is that it would be something dynamic and as we close new months that become current months Pigment would understand that the YTD info has to be updated.

Best answer by Benoit

Hi,

It seems to me that your formula should probably look like this:

Yeartodate(metric[filter: Version.”Actuals”])

 

Let me know if this helps.

Best,
Benoit

3 replies

abhilashsawla
Master Author
Forum|alt.badge.img+7

Hi

You can calculate it by Yeartodate function.

 


Forum|alt.badge.img
  • Author
  • Apprentice Author
  • July 20, 2023

Hi,

 

Many thanks for your reply!

I’m trying to do it by Yeartodate function but I have the error that I attach in the screenshot. Do you know how can I solve it?
 

 


Benoit
Community Manager
Forum|alt.badge.img+15
  • Community Manager
  • Answer
  • July 21, 2023

Hi,

It seems to me that your formula should probably look like this:

Yeartodate(metric[filter: Version.”Actuals”])

 

Let me know if this helps.

Best,
Benoit