1. Eg. Data in excel sheet with columns(A, B,...H) and rest are the values for the corresponding columns.
  3. COLUMN A,B belongs to SourceTypeA
  4. COLUMN C,D,E belongs to SourceTypeA
  5. COLUMN F,G belongs to SourceTypeA
  7. A B C D E F G H
  9. 4778521 3174 26 172265 19441 0 3 63337
  10. 0 12546 0 0 0 0 0 0
  11. 0 8613 0 0 0 0 0 0
  12. 0 0 0 0 0 0 0 0
  13. 0 874 0 0 0 0 0 0
  15. Formula - ((A/((SUM(A,B,H)-SUM(D,C,G,E,F)))100))
  17. We want to calculate above Formula in Splunk using above values.

Splunk Query