Forum Discussion
Multiplication Between Columns in the same matrix
Hello,
One way you can consider doing this is with the following:Measure = VAR _FLB = Your Calculation VAR _FCT = Your Calculation VAR _Cycle = Your Calculation VAR _Run = Your Calculation RETURN _FLB * _FCT * _Cycle * _RunFor extra validation, I would ensure each variable computes the result you expect. I'd recommend Returning each variable first before you do the full multiplication. i.e.
Measure = VAR _FLB = Your Calculation //VAR _FCT = Your Calculation //VAR _Cycle = Your Calculation //VAR _Run = Your Calculation RETURN //_FLB * _FCT * _Cycle * _Run _FLBAnd repeat for each variable so that you can trust you answer
Hello,
One way you can consider doing this is with the following:
Measure =
VAR _FLB = Your Calculation
VAR _FCT = Your Calculation
VAR _Cycle = Your Calculation
VAR _Run = Your Calculation
RETURN
_FLB * _FCT * _Cycle * _Run
For extra validation, I would ensure each variable computes the result you expect. I'd recommend Returning each variable first before you do the full multiplication. i.e.
Measure =
VAR _FLB = Your Calculation
//VAR _FCT = Your Calculation
//VAR _Cycle = Your Calculation
//VAR _Run = Your Calculation
RETURN
//_FLB * _FCT * _Cycle * _Run
_FLBAnd repeat for each variable so that you can trust you answer
Thank you for your reply. However, I have a problem to appoint these variance respectively in different stage.
Ex. How can I appoint the Y/R % when stage in NR. FLB TEST.
My caculation is below.
Y/R % = DIVIDE(([Input Q'ty]-[Defect Q'ty]),[Input Q'ty])Defect Q'ty = CALCULATE(COUNT(stage[#]),'stage'[Pass/Fail]="Fail")+0Input Q'ty = COUNT(stage[#])Thanks.
Oh, I figure it out. Thank you very much!!!
