Forum Discussion

norbi's avatar
norbi
Icon for Helper I rankHelper I
8 years ago

Annual percentage split on different items and split value accordingly

Hi, I would truly appreciate some help with the following challenge. I have a total val for a year and the percentage split over the period. I would like to combine these where Table_1 would have th...
Need Help
norbi's avatar
norbi
Icon for Helper I rankHelper I
8 years ago

Hi Vvelarde,

 

Thank you for the file, it works on the data thank you. Would it be possible to add something like this to a measure instead of a table? Reason for this is that my actual data has many fields and currently getting and error “The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value.”?

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

I have solved this problem using Query Editor.  Download the file from here.

 

  • norbi's avatar
    norbi
    Icon for Helper I rankHelper I
    8 years ago

    Hi Ashish_Mathur,

     

    Whn looking at the attached document, the two tables are only in two tables, however the % split for the months is not present?

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    8 years ago

    Hi norbi,

     

    Table_1 has the final answer.  Table_2 is where you will see the monthly split.