Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
I am facing one issue in straight table to suppress the zero values based on the external button selection (Not Check the Suppress Zeros in Presentation tab).
I have table like the below
SuppressZero, All Values
Account_ID, ActualDate, TransforDate, Charges, CD, Discount, NetRevenue(Charges+CD-Discount), NetPayments, Balance (NetRevenue-NetPayments)
101, 10/11/2022, 23/11/2022, 500, 50, 30, 520, 460, 60
102, 11/11/2022, 24/11/2022, 450, 100, 50 500, 500, 0
103, 12/11/2022, 25/11/2022 350, 0, 100, 250, 250, 0
104, 13/11/2022, 26/11/2022, 650, 150, 0, 800, 900, -100
I have My data like the above, when i click on Suppress zero button here i don't want see the records (102,103)with zero values in the Balance column records, If i click on All values button then i could see all the values in the table.
Don not click on the Suppress Zero values in Presentation tab.
Could you please help here how to approach.
Thanks in advance
As far as I know, you can't actually do this directly. Your best bet would be to create two separate tables, one with Suppress Zero enabled and one where it is disabled, and then use a button / variable to toggle which one is shown.