Expression Calculation

[Anonymous]

Hi,

I have a requirement where I need to show if the revenue by part and project for any year is less than 100k or not.

Table 1

Expression for Revenue: Sum({assignmenthod-={'SaaS'}>}Revenue)

Expression for less? :  If(Column(1)<=100000,'YES','NO') where column(1) is the expression for Revenue.

Table 2

I have added the quarter column in this table. As you can see when the revenue is broken down by quarter, the values for project 123 becomes less than 100,000 for each quarter and as a result gives me 'YES' for column 'Less?'. I need to show 'NO' if the total value of the project and part exceeds 100k in that year but also show it broken down by quarters. How do I achieve this? Thanks!

gwassenaar‌ jagan‌

[vishsaggi]

May be try this? Sorry missed the dimensions

= If( Sum(TOTAL <Part, Project, Year> {< assignmenthod-={'SaaS'}, Quarter= >} Revenue) <= 100000,'YES','NO')