Jun 29 2022 04:50 AM
How calculate percentage of i.e. Total Rs.6600*500% in Power Pivot.
formula is given below and also excel sheet is attached for ready reference.
500% percentage of increase:=[Total]*500
Yours cooperation will be highly appreciated.
Regards
Jalil
Jun 29 2022 06:46 AM - edited Jun 29 2022 06:47 AM
@Jalil1985 Looked at your "data model" and don't really understand what you want to do. But, a a general note, 500% = 5, so you should multiply the whatever base number you have by 5, not by 500.