Margin Calculation

[qlikviewaf]

Hi Guys,

i created a report with the following expression.

I would like to add an expression and use the [COGS YTD $(vYear)] directly in the expression, is something possibile?

which is the syntax?

Imagine another expression called MARGIN where the expression is = [COGS YTD $(vYear)] / [Revenue YTD]

[Anil_Babu_Samineni]

Yes, This label of expression we can use like Measure with in the expression. Will you provide more info related same

[#3]

='COGS YTD $(vYear)'

[qlikviewaf]

Not working.. look

[#5]

Works for me.  Can you show me the definition of your year variable?

[Anonymous]

When I did this calculation I put the 2 amounts/calculations (vCOGS and vREVENUE) into variables then directly input the expression into the Margin% column [ =(vCOGS - vREVENUE) / vREVENUE ]