Dimension Reference Line - can't use variable / master label / calculation in Expression

[ziabobaz]

Apart from hard numbers (which works), I can't use dynamic dimension reference line. I tried using variables or formulas - it does not work. 

Is it a bug or a feature?

Thank you!

[kaushiknsolanki]

Hi,

It should allow you to write a function for a value.

What expression you have used which didn't work?

[ziabobaz]

hi there!

this is the Dimension formula:

Number of Orders by AOV 

=AGGR(	Class( [AvgOrderValue], 1500), OrderN)

This is the formula for Dimension reference:

Total Average Order Value

=SUM( {< Cal={'CP'} >} Sales)
/
Count( DISTINCT {< Cal={'CP'} >} OrderN)

[ziabobaz · Accepted solution]

Figured it out myself:

=Floor( [AvgOrderValue], 1500 )