Hello,
Is it possible to do the following calculation in SAC.
1. Multiply all values in column A that are individually less than 0.5*average of column B.
2. Multiple the unchanged values of column A by a common factor such that the sumproduct o...
Hello Nikhil, thank you for the suggestion. This is exactly how I'm trying to do it. However, I'm finding it difficult to figure out the average and sumproduct formula (for the entire measure). Bcos its basically one average value of col A thats bein...
