Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can anyone please let me know what this code is doing? Thanks in advance for the help!
Count(Distinct {1<Approximate_Flag_1 = {0}, No_Map_Flag_2 = {0}, Combination_Flag_3 = {0}, Scenario_Flag_4 = {0}, Choice_Flag_5 = {0}>} MCG_Code)/Count(Distinct Total{1< Approximate_Flag_1={"*"}>} MCG_Code)
It counts the number of distinct MCG_Code that have the Approximate_Flag_1, No_Map_Flag, Combination_Flag_3, Scenario_Flag_4, Choice_Flag_5 with the value 0 and divides it with a count of the number of distinct MC_Code with whatever Approximate_Flag_1 (The "*" might exclude null values). This expression ignores all user selections.
Karl