Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was creating sales analysis dashboard and I used three text object to display Actual, Forecast and Actual/Forecast which is the sum of Actual and Forecast. The value for Actual, and for Forecast displayed correctly, however the Actual/Forecast didn’t calculate properly whenever I select for different period.
But when I create this in straight table, the result for all three columns look correct, because I can add column(1) + column(2) for the last column which is Actual/Forecast.
Any suggestions on this please?
Thanks,
Wossen
What is your expression for Actual and Forecast? May be like this
Sum(Aggr(RangeSum(Actual'sExpression, Forecast'sExpression), YourDimensions))
Hi Sunny,
Thanks for your rely.
I have an expression like this :
For Actual = Sum(Shipment * price)
For Forecast = Sum(Forecast * price)
For Actual/Forecast = (Sum(Shipment * price) + Sum(Forecast * price))
Even I tried to do with variables
For Actual = Sum(Shipment * price) => assigned vActual
For Forecast = Sum(Forecast * price) => assigned vForecast
For Actual/Forecast = (Sum(Shipment * price) + Sum(Forecast * price)) then used ( Sum(vActual + vForecast))
So Actual and Forecast are working in text object but Actual/Forecast isn't? That is very strange? Would you be able to share a sample to show the issue?
Are the Forecast and Shipment data in different tables? That might explain why filtering on a date might give different results
Hi David,
They are on the same table. What makes me puzzled is when I used the expression on straight table,looks correct and when I applied the same expression on text object doesn't look right! Did I miss something here?
I was thinking that given you're using them on the same table and it was working was because the table would be using the underlying table JOIN implicitly, and hence without enforcing a filter on all of the data at once would then give a different outcome I think.
Can you identify the number that is wrong? Maybe chuck the data into excel and play with a pivot table and see if you can spot it if there's nothing obvious like filters or joins getting in the way.