cancel
Showing results for 
Search instead for 
Did you mean: 

Logic of 4 quater data

thrilu_g
Member
0 Kudos
369

Hi everyone,

I don't have much knowledge on writing a scrpit. Can someone help out the scenario how to write the logic.

Scenario: Total Revenue-total cost/total revenue and where four quater of data need to read and post the calculated value in 5555.9

Her four Quater data means For Ex: if user select 2022.Q3 then data need to read for 2022.Q2,2022.Q1,2021.Q4,2021.Q3

Note : In time dimension we don't have month everything is quater maintained for ex: 2022.Q1,2022.Q2...etc

So can someone help on the logic syntax.

Thanks in advance!!!

Accepted Solutions (0)

Answers (0)