Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Need help on the calculation

Hi Experts,   I needa help on the calculation.   Here is the example. I want o created a Column and display the latest data in the month.   Here, I want to created a Column as "YTD Act"  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

No, I have created month column as calculated and i want to get the latest month's value.

 

Regards

swamy

JirkaZ's avatar
JirkaZ
Icon for Solution Specialist rankSolution Specialist
6 years ago

Anonymous Why do you have it as a calculated column? Don't you have a date table in your model that you could use for that? Then the TOTALYTD would work.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    Yes I  have, but the problem is there a different logic for each country in the report, so i have to arrive the expected the results based on the logic for that i have to create the calculated column. No other way.

    • JirkaZ's avatar
      JirkaZ
      Icon for Solution Specialist rankSolution Specialist
      6 years ago

      Anonymous Could you please clarify the various rules for certain countries? There might be a way around that.