Import Calculations

patroser — Thu, 02 Jul 2015 16:47:38 GMT

Hi there,

it feels like being stuck right in front of the solution to my problem, but I can't really figure it out.

I guess I missed something pretty easy...

I have an excel sheet containing some IDs and some calculations.

What I'm trying to do, is display a chart with the IDs as dimension and the result of each IDs calculation.

I tried using "$(=only({<ID={$(=RowNo())}>}Expression))" assuming, that RowNo would return the correct ID for each Row.

Is there any clean way to calculate each expression for each ID? Worst case could be, that the ID is alphanumeric, therefore RowNo wouldnt work.

Please find attached the example.

Thanks in advance

Patrick

Re: Import Calculations

Gysbert_Wassenaar — Thu, 02 Jul 2015 16:59:25 GMT

patroser — Fri, 10 Jul 2015 10:51:22 GMT

This works for me, thanks!

I just didn't know, that the $-Expressions are evaluated outside the context of the charts dimension.

Patrick