Hi Team, Please help me to know the formula for the below scenario. [image] As mentioned in the above image, I need formula for, if (EAdate <= today) & (actual = 0 ) --Highlight Red color This is a Pivot chart, EADate in Rows, TargetActual in column, with two data split as (Target & Actual) …

Hi @Meena1 Could you please create a calculated field to handle null values in Quantity and then use it in your calculation. Example: ifelse(isNull(Quantity), 0, Quantity) Try the following approach to visually indicate any missing dates in your report. Create a calculated field (measure) to ac…

Quick sight formula required

Q&A

Xclipse March 28, 2025, 4:21am 5

Hi @Meena1

Could you please provide me with the sample non-sensitive data and explain what you are attempting to obtain?

If you can recreate this issue in Arena using sample non-sensitive data, I can take a deeper look to see what is going on.

1 Like

Topic		Replies	Views
How to conditionally format dates in quicksight matrix Q&A formatting , quicksight	3	550	November 17, 2022
Conditional formatting based on column Q&A formatting	3	7270	August 4, 2022
How to color the values of the table based on the condition on rows and columns Q&A charts , filters , quicksight , visuals , filters-controls-and-parameters , calculations , Business-Intelligence-Engineer , tables	16	1292	May 15, 2024
Add conditional formatting for each row as target value for each row is different Q&A calculations , how-to	1	260	July 20, 2023
Conditional Formatting Pivot Table Values - "Redacted" Text? Q&A analysis , formatting , how-to	3	616	September 26, 2022

Quick sight formula required

Related topics