Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
So what is your question?
Can you give a better description of what you are trying to achieve?
I have no idea what you're trying to say. If you have a question you'll have to ask it a bit more clearly.
I want to form a KPI metrics(UI Design) .I have Manufaturing date / Delivered product / Incorrect product.
I have to calculate actual month = last 30 days and also actual month = last 30 days ... can any one of you can provide me the formulae or set analysis for the same
for Ex..
=((sum({<[Manufacturing year]={$(vCurrentYear)}, [Manufacturing month]={$(=vCurrentmonth),$(=vLastmonth)}>}[Incorrect Quantity])/sum({< [Manufacturing year]={$(vCurrentYear)},[Manufacturing month]={$(=vCurrentmonth),$(=vLastmonth)}>}(PosMenge))*1000000
/(sum({< [Manufacturing year]={$(vCurrentYear)},[Manufacturing month]={$(=vLastbeforemonth)}>}[Incorrect Quantity])/sum({< [Manufacturing year]={$(vCurrentYear)},[Manufacturing month]={$(=vLastbeforemonth)}>}(PosMenge))*1000000))*100)-100&'%'
I need previous 30 days instead of months ..
The actual month is August: Month(Today())
You can replace below piece of set analysis in your expression
[Manufacturing date]={">=$(=date(max([Manufacturing date])-30)"}
Remove [Manufacturing year]={$(vCurrentYear)}, [Manufacturing month]={$(=vCurrentmonth),$(=vLastmonth)}
Hi Kush,
Thanks for the first one
can you please provide me the 2. month before = last 30 days to last 60 days
HI,
Try like this
[Manufacturing date]={">=$(=date(max([Manufacturing date])-60)<=$(=date(max([Manufacturing date])-31)"}
Hope this helps you.
Regards,
jagan.
try below set expression
=Sum({<[Manufacturing date]={">=$(=date(max([Manufacturing date])-60))<=$(=date(max([Manufacturing date])-31))"},[Manufacturing year]=,[Manufacturing month]=>}PosMenge)