Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Oskar_vl
Partner - Contributor II
Partner - Contributor II

Waterfall Chart two values in value Description

Hey Community,

 

I try to bring two values, one abolute and one percent value in the value description. 

Here is the abolut formula:

 

=num(
sum(
{<
[name]={'production'}
>}
[endtime]-[starttime]
)
*24*60
,'#.##0 Min. $(vProductionPercent) ')

 

I try it with a variable but then i get two extra 00 in my value. Below how it actualy look like and how it should look like.

 

 

Unbenannt.PNG

 

Any ideas? 

Thank you very much

greetings Oskar

2 Replies
dplr-rn
Partner - Master III
Partner - Master III

try changing your formula to something like below
num(
sum(
{<
[name]={'production'}
>}
[endtime]-[starttime]
)
*24*60
,'#.##0') & 'Min.' & $(vProductionPercent)
Oskar_vl
Partner - Contributor II
Partner - Contributor II
Author

This is the formula you see on the right in the Chart.
When I use this the description it is perfekt bud the value itself is missing.

num(
sum(
{<
[name]={'production'}
>}
[endtime]-[starttime]
)
*24*60
)
,'##.##0 Min.')
&
'$(vProductionPercent)'