Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Currently I have the below graph based on a value in the table (TIJD)
I do however want to base it on a calculated value. For this calculated value I created a Variable : vTL%
vTL% : (((Sum({<VolgNr ={1}>}[Tijd]) + Sum({<VolgNr ={2}>}[Tijd])+Sum({<VolgNr ={3}>}[Tijd]) + Sum({<VolgNr ={4}>}[Tijd])+Sum({<VolgNr ={5}>}[Tijd]) + Sum({<VolgNr ={6}>}[Tijd])+Sum({<VolgNr ={7}>}[Tijd])
+ Sum({<VolgNr ={8}>}[Tijd])+ Sum({<VolgNr ={9}>}[Tijd]) + Sum({<VolgNr ={10}>}[Tijd])+ Sum({<VolgNr ={11}>}[Tijd]) + Sum({<VolgNr ={12}>}[Tijd])) / Sum({<OE_HfdCode={'TijdBenut'}>}[OE_Tijd]))) * 100
Putting this in the default expresion does not work Sum({<[Zone]={'Zone 9-10'}>} $(vTL%))
How must I setup my expression to make this work?
Thanks.
Jan
I'll follow your advice.
Thanks for helping so far.
Jan Droog