Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 increase 30% on Net Amount value
Please help me to write the logic.
Thanks in advance.
May be this:
Sum(Aggr(
(Sum({<[Date]={">=$(=addmonths(today(),-12))"},[Type]={'Level1'},[ Name]={'AA','BB','CC','DD'}>} If([Status] = 'Not Completed', 1.3, 1) * [Net Amount])
/
Count({<[Date]={">=$(=addmonths(today(),-12))"},[Type]={'Level1'},[ Name]={'AA','BB','CC','DD'}>}distinct[Repairs])
),[MonthYear]))
May be this:
Sum(Aggr(
(Sum({<[Date]={">=$(=addmonths(today(),-12))"},[Type]={'Level1'},[ Name]={'AA','BB','CC','DD'}>} If([Status] = 'Not Completed', 1.3, 1) * [Net Amount])
/
Count({<[Date]={">=$(=addmonths(today(),-12))"},[Type]={'Level1'},[ Name]={'AA','BB','CC','DD'}>}distinct[Repairs])
),[MonthYear]))
Hi @rahulpawarb
Could you please explain why 1.3 is considered. I assume for 30% need to multiply with 0.03.