Percentage problem

[rvp68]

Hi all,

Hope this neewbie question will find an answer...

My goal is to display percentage values like this:

-- removed inline image ---


But as soon as I expand, I obtain wrong values:
{moderator note - bad IMG HTML removed}

nd my formulas:

-- removed inline image ---

Total-Qty:=SUM([Quantity])
Total-Qty-Shop:=CALCULATE(SUM([Quantity]);ALL(Sales[Shop]))
%:=DIVIDE([Total-Qty];[Total-Qty-Shop])


Any help would be very much appreciated, thanks in advance.
rvp68

 

[Jon von der Heyden]

Hi rvp68

You need to upload your image to a cloud directory if you want to display them here. You cannot upload to MrExcel server.

Alternatively you can try and demonstrate your requirement by posting a table to the thread. More info here: http://www.mrexcel.com/forum/about-board/508133-attachments.html

Regards
Jon