Forum Discussion

Kiattipoom_T's avatar
Kiattipoom_T
New Member
2 years ago

Calculate Data with measure

Hi,

I've tried to choose value (from measure) to multiply with my data but I can't do it

First I have create cumulative data like this

Remark "Year" in row is different from column (Year in row is Underwriting Year in Insurance, Year in Column is Accounting Year)

And then I create measure "Develop factor" [ Column Year/(Column Year - 1) ]


Then I calculate "Average Develop factor" by Accounting Year(Column Year) in header like this

Now I Want to multiple "Average Develop factor" with my data in first pic
for example
Last Data in Row Year 2020 =197,367,734.42 * Average Develop factor in Column Year 2022 = 0.99
=197,367,734.42 * 0.99
Last Data in Row Year 2021 =205,929,963.92 * Average Develop factor in Column Year 2021 & 2022 = 0.89 * 0.99
=205,929,963.92 * 0.89 * 0.99


Is it possible to do like this?
Sorry for any confused, I'm not Good in English 🙏

Thanks,

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Kiattipoom_T ,

    In order to better understand your demands and give the right solution, could you please provide some more specific information? such as your desensitized example data and a screenshot of your desired results?

    Thanks for your efforts & time in advance.

     

    Best regards,
    Community Support Team_Binbin Yu