0 Replies Latest reply on Nov 15, 2018 10:50 AM by Lakshmi Palisetty

    Grand total issue

    Lakshmi Palisetty

      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

       

      Thanks