Miscellaneous Functions

Function  
Description This functionality allows you to drill through on calculations.
Arguments  
Examples
  • if (Area_Name=’Birmingham and North Midlands’) {drillthru(1)}
  • CASE WHEN Area_Name=’Birmingham and North Midlands’ THEN drillthru(1) END
Function /*<comment>*/
Description Comments can be added to calculations by using /*. This provides detail as to what the function does.
Arguments  
Examples
  • CASE WHEN MOP_Payment = ‘Cash’ THEN 1 ELSE 0 END /*This calculation brings back CASH only payments*/