Using Variable In Straight Table

[dmac1971]

I have a simple variable, vKPI.Backlog.#Lines,  that allows me to count total lines :

=count({<KPI = {'Backlog'}>}Order_ID)

And as a total count this works fine.  When I use this in a straight table using customer as dimension and the following as the exp:

$(=vKPI.Backlog.#Lines)

I get the overall total for all customers against each customer.  Is it not possible to use a variable like this in a straight table?

[shraddha_g]

Share screenshot of table.

What are the fields you have used? and are those linked?

[marcus_malinow · Accepted solution]

Hi Dermot,

change your variable to

count({<KPI = {'Backlog'}>}Order_ID)

by removing the equals sign

And your expression to

$(vKPI.Backlog.#Lines)

[dmac1971]

Marcus, Doh!  I knew it would be something simple, many thanks!