If you are unable to create a new account, please email bspsoftware@techdata.com

Author Topic: Help with Context Formula in calculating percentage  (Read 103 times)

Offline rajua99

  • Full Member
  • ***
  • Join Date: Jun 2009
  • Posts: 42
  • Forum Citizenship: +0/-0
Help with Context Formula in calculating percentage
« on: 15 Mar 2023 12:49:57 pm »
Hello Team,

In my report i need to calculate Percentage based on Revenue for each row by year-month.

from the below data for Rock & sand for year month 2022-03 i need to divide that row with Revenue row i.e 99,816.66/2,032,952 and calculate the percentage.

HECTOR M MICHEL   ROCK & SAND                                                  2022-03           99,816.99      
HECTOR M MICHEL   REVENUE CONCRETE                                     2022-03      2,032,952   

Do the similar for other rows based on Year - month for each cost type description.

Can you please help me how to create formula by keeping context in place so that the % is calculated properly.