Expression help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have an Average Net Amount expression like below here I am dividing the Sum of Net Amount by Number of Repairs.

Sum(Aggr(
(Sum({<[Date]={">=$(=addmonths(today(),-12))"},[Type]={'Level1'},[ Name]={'AA','BB','CC','DD'}>}[Net Amount])

/
Count({<[Date]={">=$(=addmonths(today(),-12))"},[Type]={'Level1'},[ Name]={'AA','BB','CC','DD'}>}distinct[Repairs])

),[MonthYear]))

Here requirement is

when [Status] = Completed then don't add any VAT on [Net Amount] need to consider the actual amount like((Sum({<[Date]={">=$(=addmonths(today(),-12))"},[Type]={'Level1'},[ Name]={'AA','BB','CC','DD'}>}[Net Amount])) but 

when [Status] = Not Completed then need to add 30% VAT on  Net Amount value  for the above expression

Please help me to write the logic.

Thanks in advance.

[dwforest]

if([Status]='Complete', your formula, your formula * 1.3)

[mahitham]

Hi @dwforest 

For 30% increase its  0.30 right instead of 1.3