Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Don't know how to properly title this question.
PML % is calculated by a couple of measures available in this table. PML is by Report Date, Schedules, and Fabric Number. Each Schedule can have more than one Fabric Number. Each Fabric Number has their own measures that is used to calculate Fabric Number level PML%. The table in this app does not have Fabric Number column, since users usually view PML% on the Schedules level.
Since PML % is viewed on Schedules level, but their can be multiple entries inside each schedule, PML % only shows up once for each Schedule. In other instance, PML % is null. Is there anyway to fill the column, so that, for example, the second PML% is also 1.757% and the fourth one is 1.775% ?
I am assuming you are using some kind of aggr() calculation for PML%.
Adding a NONDISTINCT into that function might help you, like this.
AGGR(TOTAL ....)
I am assuming you are using some kind of aggr() calculation for PML%.
Adding a NONDISTINCT into that function might help you, like this.
AGGR(TOTAL ....)
It's possible to show the PML% values using the TOTAL Keyword as suggested by @Vegar
Sum(TOTAL <Product,Schedule,Fabric> PML )
but if you intend to use this value for further calculations I would suggest you Map the Values in a new column in your data model
Use either Applymap() or Joins to add a new column with PML values for all rows at the required level