Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the below data
Grade | Name | Money1 (Will not change) | Money2 | Category |
---|---|---|---|---|
A | Vice President | 10000 | 11000 | (if variance% between money1 & 2 is <20%, then show the value) |
B | Delivery Head | 15000 | 13000 | (if variance% between money1 & 2 is <20%, then show the value) |
C | Operations Manager | 18000 | 19000 | (if variance% between money1 & 2 is <20%, then show the value) |
The column Money1 will not change, the column money 2 will be picked up from the raw data and compared against the column "Grade".
I want to calculate if variance% between money1 & 2 is <20% for each of the grade and then the category should the value %)
We've got like below
In your example, I don't think which value we need to pick condition is fulfillment. Would you explain little more
Hi Anil, in the dataset, I have a column which has the actual package offered, i want to compare it to the column 'Money1' and see the variance. If the variance is >20%, the category should show as '>20%' else it should show '<20%'
You can do like below
I assume, you may have Variance column with you for Column(3)
The condition should be like below
Sum(Aggr(If(Column(1) = Column(3) or Column(3) >= '0.2', '>=20%', '<20%'), Grade, Name))
Hi Swamy,
Do the above calculation in load script itself:
LOAD Grade,
Name,
Money1,
Money2,
If(((Money2-Money1)/Money2)*100 < 20,((Money2-Money1)/Money2)*100 ) as Percentage
FROM
(ooxml, embedded labels, table is Sheet1);
Regards,
Pankaj