how to calculate your expressions base on multiple unit

[#1]

See snapshot above;

I have 2 expressions Actual and Target, how do i calculate base on the unit ex: the %

[sunny_talwar]

Not entirely sure about what you are trying to achieve here. Calculate base on the unit? how would you do this out of QlikView (an example would help us understand your question much better)

Best,

S

[#3]

I wanna make a condition such that when unit is % it calculate percentage in expression

[simondachstr]

You need a conditional statement which checks whether Unit is Days, Mins or %. Maybe use something like this:

pick(Match([Unit],'Days','Mins','%',), [Expression for Units per Days],[Expression for Units per Mins],[Expression for %])

[sunny_talwar]

Trying to achieve this?

Use the following expression with your field names:

=If(Unit = '%', Num(Sum(Value)/100, '#,##0.0%'), Num(Sum(Value), '#,##0'))

HTH

Best,

S