Skip to Content
0
Jul 07, 2020 at 12:50 PM

Lumira Designer Issue with per /MT values, its summing up..percentages not shown, summing up.

43 Views

Hi All,

i was trying to plot a graph with a keyfigure that is Cost/MT. however, the cost/MT is getting added up and not showing individual value. for example

year 1, month 1, product 1, qty 10, cost 200, cost /mt = 20

year 1, month 1, product 2, qty 10, cost 300, cost /mt = 30

year 1, month 2, product 1, qty 5, cost 200, cost /mt = 40 ( price changed )

year 1, month 2, product 2, qty 4, cost 300, cost /mt = 70 ( price changed )

if i take cost /mt for each month it should be

month 1, total qty 20 total cost 500 so cost /mt = 25/MT

but instead what i get is its summed up, that is 20+30 = 50/ MT

when i see in "Edit Query Specification" mode its coming correctly as 25/MT, but in "Edit Initial View" mode of query, it summing up that is 50/MT

any way we can fix this issue.

your support wil be greatly appreciated.

thank you.