Hi All ,
I am facing some strange scenario while displaying GRAND TOTAL
I have attached .twbx file.
below is my requirement
1) Displaying Avarage Price for Baseline and Current (order amount/Order Quantiy) -- Its working fine in rowlevel
2) Here i have to calculate OPI $ vakue by using business logic i.e ( Current Avarage Price - Baseline Avarage Price) * Current Order Quantity -- This is working fine at row level
In this attached .twbx file to explain the issue i am using 2 account names as an example.The issue here is for one of the account SETPOINT INTEGRATED SOLUTIONS (CN) the grand total should display 22278 for the other account grand total should display 7281
For first account grand total is displaying as expected (22278) where other account not displaying anything for OPI $ Grand Total.So to resolve this NUCLEAR grand total issue I used ZN function for OPI calculated field then GRAND TOTAL is coming as expected 7281 where as
SETPOINT Grand total displaying different random value which is earlier displaying properly before using ZN
In nut shell, the row level data is displaying properly but grand total is not coming as expected.
Could you please do the needful