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



MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Help with Context Formula in calculating percentage

Started by rajua99, 15 Mar 2023 12:49:57 PM

Previous topic - Next topic


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.