Skip to Content
0
May 23, 2020 at 04:12 AM

WebI Variable help

81 Views Last edit May 23, 2020 at 05:16 AM 2 rev

Hi All,

Can someone help me in creating a variable for this column?

I have created the first 4 columns. I am trying to create CPRO Count CY.

How to make sure the variable is picking the date for Current year/previous year from column correctly for that column?

CPRO Count CY - To Calculate this - I have "CPRO Indicator =Yes" and I have a "Count Column" already.

I need to do - RO Count where CPRO Indicator = Yes for each CY date(Date Column) value showing in the attachment.